请教:将dataset更新到后端数据库,欢迎讨论,解决即结
tihua 2004-10-15 04:28:52 手工建立datatable,并把它作为datagrid的数据源,我要把datagrid的数据更新到数据库里该怎样做呢?有以下思路但不知怎样实现:循环datatable的row,取出每一行的数据并将它赋于变量(每个变量对应一个datatable的字段的值) 然后用sql语名insert into 表(字段1,字段2)values (变量1,变量2)把它更新数据库,不知您怎样看?或如何解决这类情况?(分数不够再开贴)附前部分代码:
Dim wastageinset As New DataSet
Dim wastageintable As DataTable = New DataTable("wastage_b")
Dim col_po As New DataColumn
Dim col_wastageId As New DataColumn
Dim col_sl As New DataColumn
With col_wastageId
.ColumnName = "代码"
.DataType = System.Type.GetType("System.String")
.DefaultValue = ""
End With
With col_sl
.ColumnName = "数量"
.DataType = System.Type.GetType("System.Int32")
.DefaultValue = 0
End With
wastageintable.Columns.Add(col_wastageId)
wastageintable.Columns.Add(col_sl)
wastageinset.Tables.Add(wastageintable)
Me.DataGrid1.DataSource = wastageinset.Tables(0)