再問︰sqlDataAdapter.update的問題,不報錯,但表就是沒有更新﹗
一開始"select * from " & tableName時我的表只是一個空表,我想將DS中的數據插入到這個表中,但剛查看了 myDataAdapter 的INSERTCOMMAND(這是我期望的操作),發現為Nothing.
代碼如下,各位幫我看看,這個問題把我搞暈了。
Private Sub updateTable(ByVal ds As DataSet, ByVal tableName As String)
Dim myConn As SqlConnection
Dim myDataAdapter As SqlDataAdapter
Dim myCommandBuilder As SqlCommandBuilder
Try
myConn = New SqlConnection(Func.ConnString)
myConn.Open()
myDataAdapter = New SqlDataAdapter("select * from " & tableName, myConn)
myCommandBuilder = New SqlCommandBuilder(myDataAdapter)
myDataAdapter.Update(ds.Tables(tableName))
Catch ex As Exception
Response.Write(ex.Message)
Finally
myConn.Close()
End Try
End Sub
該問題的另一貼子︰
http://community.csdn.net/Expert/topic/4665/4665926.xml?temp=.6138117