16,554
社区成员
发帖
与我相关
我的任务
分享
Private dbsql As Global.LzmTW.Data.DatabaseHelper = New Global.LzmTW.Data.SqlSqlClientDatabase(".", "Northwind")
Private dbexcel As Global.LzmTW.Data.DatabaseHelper = New Global.LzmTW.Data.ExcelOdbcDatabase("g:\office\new.xls")
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim tablename As String = "Customers"
Dim table As DataTable = dbsql.GetDataTable(tablename)
Dim result As Boolean = dbexcel.ImportTable(tablename, table, New String() {"CustomerID"})
Console.WriteLine(result)
Me.DataGridView1.DataSource = dbexcel.GetDataTable(tablename)
End Sub
'新增数据到一个新表,目的是使行的Rowstate为Add以便DbDataAdapter进行Update
Dim newTable As DataTable = table.Clone
newTable.Load(table.CreateDataReader, LoadOption.Upsert)
'指定OrderID为主键进行更新
db.Update("Orders", newTable, New String() {"OrderID"})