诸位大侠,求救求救,vb.net关于数据更新--使用InsertCommand?
我想使用OracleDataAdapter,将数据库中的表更新。
代码如下:
Public Sub updateDatabase_net(ByVal newDataSet As DataSet, ByVal tableName As String)
Dim tmpDataAdapter As New OracleDataAdapter
Dim connectionString As String = "User Id=" + tmpUserName & _
";Password=" + tmpPassWord & _
";Data Source=" + tmpDataSource
Dim tmpConnection As OracleConnection
tmpConnection = New OracleConnection(connectionString)
tmpConnection.Open() '连接数据库
Dim tmpCommand As New OracleCommand
tmpCommand.Connection = tmpConnection '设定SQL连接对象
tmpCommand.CommandType = CommandType.StoredProcedure
'创建insert命令
tmpCommand.CommandText = "insert worker (id,name) VALUES(?,?)" 'worker为数据库表的名称
tmpCommand.Parameters.Add("@p0", OracleDbType.Long, 4, "id")
tmpCommand.Parameters.Add("@p1", OracleDbType.Varchar2, 10, "name")
tmpDataAdapter.InsertCommand = tmpCommand
tmpDataAdapter.Update(newDataSet, tableName) '此处出错,请教!!!!!!!
End Sub