古筝十大名曲mp3下载:“System.Data.OleDb.OleDbCommand.recordsAffected”是“Private”,因此它在此上下文中无法访问
来源:百度文库 编辑:高校问答 时间:2024/07/07 08:11:43
我是asp.net的初学者,在与access的数据库连接的时候出现提示
’System.Data.OleDb.OleDbCommand.recordsAffected’ is not accessible in this context because it is ’Private’.
请教~~~
原代码:
<%@Import Namespace=System.Data.OleDB%>
<%@Import Namespace=System.Data%>
<Html>
<Form id=“F1“ Runat=“Server“>
请输入SQL语句:
<Input Type=“Text“ Id=“Text1“ Runat=“Server“ >
<Button ID=“Button1“ Runat=“Server“ OnServerClick=“Button1_Click“>执行</Button>
<asp:label ID=“Sp1“ Runat=“Server“/>
</form>
<Script Language=“VB“ Runat=“Server“>
Sub Button1_Click(sender As Object, E As EventArgs)
Dim cnA As New OleDBConnection
Dim cmA As New OleDBCommand
cnA.connectionstring=“Provider=Microsoft.Jet.OLEDB.4.0;“ & “DataSource=c:\inetpub\wwwroot\chap7\Members.mdb;“ & “UserID=Admin“
cnA.Open()
cmA. Connection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.ExecuteReader()
Sp1.Text=“这条语句影响了“ & cmA.RecordsAffected & “条记录“
End Sub
</script>
</Html>
’System.Data.OleDb.OleDbCommand.recordsAffected’ is not accessible in this context because it is ’Private’.
请教~~~
原代码:
<%@Import Namespace=System.Data.OleDB%>
<%@Import Namespace=System.Data%>
<Html>
<Form id=“F1“ Runat=“Server“>
请输入SQL语句:
<Input Type=“Text“ Id=“Text1“ Runat=“Server“ >
<Button ID=“Button1“ Runat=“Server“ OnServerClick=“Button1_Click“>执行</Button>
<asp:label ID=“Sp1“ Runat=“Server“/>
</form>
<Script Language=“VB“ Runat=“Server“>
Sub Button1_Click(sender As Object, E As EventArgs)
Dim cnA As New OleDBConnection
Dim cmA As New OleDBCommand
cnA.connectionstring=“Provider=Microsoft.Jet.OLEDB.4.0;“ & “DataSource=c:\inetpub\wwwroot\chap7\Members.mdb;“ & “UserID=Admin“
cnA.Open()
cmA. Connection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.ExecuteReader()
Sp1.Text=“这条语句影响了“ & cmA.RecordsAffected & “条记录“
End Sub
</script>
</Html>
RecordsAffected 属性是用来获取 “通过执行 SQL 语句获取更改、插入或删除的行数”的。
cmA是个OleDbCommand对象,不包含RecordsAffected属性。要使用这个属性,需要在数据集执行了插入、修改、删除操作的相关操作中调用RowUpdatedEventArgs参数。
System.Data.OleDb.OleDbException
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
什么情况下使用System.Data.OleDb接口和System.Data.SqlClient
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
编译器错误信息: BC30456: “add”不是“System.Data.OleDb.OleDbParameter”的成员。
System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
OLE DB 提供程序(System.Data.OleDb)要求 Microsoft 数据访问组件(MDAC)
“System.Data.OleDb.OleDbCommand.recordsAffected”是“Private”,因此它在此上下文中无法访问
我的优盘打开出现 data peng data system data dreamaster data administpsyor 文件夹是怎么回事
求I-O Data 网卡驱动。。~~