dataset绑定datagridview,怎么将更改的数据保存回数据库?
dataset绑定datagridview,如何将更改的数据保存回数据库???
Dim strCon As String
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + My.Computer.FileSystem.CurrentDirectory + "\Config.mdb "
Dim mycon As New Data.OleDb.OleDbConnection(strCon)
mycon.Open()
Mycom.Connection = mycon
Dim cmd As New OleDb.OleDbCommand
Dim strSQL As String
strSQL = "select * from 表1 "
adpt = New OleDb.OleDbDataAdapter(strSQL, mycon)
Dim MYTABLE1 As DataTable
adpt.Fill(MyDataSet, "table ")
MYTABLE1 = MyDataSet.Tables( "table ")
DataGridView1.DataSource = MYTABLE1
以上代码是把数据绑定到datagridview1上,请问如何把程序运行过程中datagridview1上更改的数据同步更新到数据库 "表1 "中呢???vb2005.请高手指点谢谢!!!
------解决方案--------------------
DataTable MYTABLE1 = DataGridView1.DataSource as DataTable;
if(MYTABLE1.GetChanges() != null)
{
adpt.Update(MyTable1.GetChanges());
}
C#语法,VB记不太清了,大概这样
------解决方案--------------------
Dim mytable1 As DataTable = DataGridView1.DataSource
if mytable1.GetChanges() <> null Then
adpt.Update(MyTable1.GetChanges())
End If
Dim strCon As String
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + My.Computer.FileSystem.CurrentDirectory + "\Config.mdb "
Dim mycon As New Data.OleDb.OleDbConnection(strCon)
mycon.Open()
Mycom.Connection = mycon
Dim cmd As New OleDb.OleDbCommand
Dim strSQL As String
strSQL = "select * from 表1 "
adpt = New OleDb.OleDbDataAdapter(strSQL, mycon)
Dim MYTABLE1 As DataTable
adpt.Fill(MyDataSet, "table ")
MYTABLE1 = MyDataSet.Tables( "table ")
DataGridView1.DataSource = MYTABLE1
以上代码是把数据绑定到datagridview1上,请问如何把程序运行过程中datagridview1上更改的数据同步更新到数据库 "表1 "中呢???vb2005.请高手指点谢谢!!!
------解决方案--------------------
DataTable MYTABLE1 = DataGridView1.DataSource as DataTable;
if(MYTABLE1.GetChanges() != null)
{
adpt.Update(MyTable1.GetChanges());
}
C#语法,VB记不太清了,大概这样
------解决方案--------------------
Dim mytable1 As DataTable = DataGridView1.DataSource
if mytable1.GetChanges() <> null Then
adpt.Update(MyTable1.GetChanges())
End If