vahidiran
یک شنبه 24 تیر 1386, 22:04 عصر
با سلام خدمت دوستان من کد زیر را در asp.net نوشتم ولی وقتی اونو اجرا می کنم خطا زیر را می ده
Operation must use an updateable query.
Dim StrCon As String
Dim StrSql As String
Dim dbconnection As New OleDbConnection
Dim command As New OleDbCommand
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\WebSiteTest\Data\DataBan k.mdb"
dbconnection.ConnectionString = StrCon
StrSql = "Insert Into DataTable(FirstName,LastName,Snn,[Avg]) Values('" & TextBox1.Text & "','" & TextBox2.Text & "'," & TextBox3.Text & "," & TextBox4.Text & ")"
dbconnection.Open()
command.CommandText = StrSql
command.Connection = dbconnection
command.ExecuteNonQuery()
dbconnection.Close()
Operation must use an updateable query.
Dim StrCon As String
Dim StrSql As String
Dim dbconnection As New OleDbConnection
Dim command As New OleDbCommand
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\WebSiteTest\Data\DataBan k.mdb"
dbconnection.ConnectionString = StrCon
StrSql = "Insert Into DataTable(FirstName,LastName,Snn,[Avg]) Values('" & TextBox1.Text & "','" & TextBox2.Text & "'," & TextBox3.Text & "," & TextBox4.Text & ")"
dbconnection.Open()
command.CommandText = StrSql
command.Connection = dbconnection
command.ExecuteNonQuery()
dbconnection.Close()