vb.net怎么从数据集保存到数据库
vb.net如何从数据集保存到数据库
vb是用rs.fields()
------解决方案--------------------
给个例子:
vb是用rs.fields()
------解决方案--------------------
给个例子:
- VB.NET code
Public Function CreateCmdsAndUpdate(ByVal dataSet As DataSet, _ ByVal connectionString As String, ByVal queryString As String) As DataSet Using connection As New OleDbConnection(connectionString) Dim adapter As New OleDbDataAdapter() adapter.SelectCommand = New OleDbCommand(queryString, connection) Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(adapter) connection.Open() Dim customers As DataSet = New DataSet adapter.Fill(customers) ' Code to modify data in DataSet here adapter.Update(customers) Return customers End Using End Function
------解决方案--------------------