datagrid编辑问题
我做了一个表 USER,做了以下处理:(1)、数据在DATAGRIDVIEW中显示了,
(2)、让DATAGRIDVIEW1.readonly= false;DATAGRIDVIEW1.allowusertoaddrows= true
Dim command0 As New SqlCommand("select ID,NEME,YEAR,SEASON FROM USER")
command0.CommandType = CommandType.Text
command0.Connection = conn
Dim dr1 As New SqlDataAdapter
dr1.SelectCommand = command0
Dim ds1 As New DataSet
ds1 = New DataSet("ds1")
dr1.Fill(ds1, "USER")
DataGridView1.DataSource = ds1
DataGridView1.DataMember = "USER"
现在想做直接在DATAGRIDVIEW1里面直接进行编辑处理,按保存BUTTON,直接保存到USER中。有这方面的代码吗?谢谢
--------------------编程问答-------------------- 利用 SqlCommandBuilder
你需要把 SqlDataAdapter 作为一个类成员。
参考下面代码
Private Function SelectSqlRows(ByVal connectionString As String, _--------------------编程问答-------------------- 实际上 Button 按下的代码,只需:
ByVal queryString As String, ByVal tableName As String) As DataSet
Using connection As New SqlConnection(connectionString)
Dim adapter As New SqlDataAdapter()
adapter.SelectCommand = New SqlCommand(queryString, connection)
Dim builder As SqlCommandBuilder = New SqlCommandBuilder(adapter)
connection.Open()
Dim dataSet As DataSet = New DataSet
adapter.Fill(dataSet, tableName)
' Code to modify data in DataSet here
builder.GetUpdateCommand()
' Without the SqlCommandBuilder this line would fail.
adapter.Update(dataSet, tableName)
Return dataSet
End Using
End Function
builder.GetUpdateCommand()
adapter.Update(ds1, "USER")
补充:.NET技术 , VB.NET