
September 16th, 2003, 04:40 PM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Update DataSaet to MySQL
I get a error message from my .aspx which I try to insert a new record into MySQL with DataSet, MySqlProv.3.0. Anyone know where is the problem?
Error message:
Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.
My coding:
Dim objCon As OleDbConnection
Dim objDataAdapter As OleDbDataAdapter
Dim strDbCon As String
Dim count As Integer
strDbCon = "Provider=MySqlProv.3.0;Data Source=atp;"
objCon = New OleDbConnection(strDbCon)
objDataAdapter = New OleDbDataAdapter("Select * from member", objCon)
Dim objCmdBilder As OleDbCommandBuilder = New OleDbCommandBuilder(objDataAdapter)
Dim objDataSet As DataSet = New DataSet
objDataAdapter.Fill(objDataSet, "member")
Dim objDataRow As DataRow = objDataSet.Tables("member").NewRow()
objDataRow("memberName") = memberName.Text
objDataRow("memberNameC") = memberNameC.Text
objDataRow("languageId") = languageId.SelectedIndex
objDataSet.Tables("member").Rows.Add(objDataRow)
count = objDataAdapter.Update(objDataSet, "member")
If count = 1 Then
msg.Text = "successful!"
Else
msg.Text = "fail"
End If
objCon.Close()
Many thanks!! Have a nice day!
Bella
|