再问DataGridView更新数据
对于不返回任何键列信息的 SelectCommand,不支持 UpdateCommand 的动态 SQL 生成
Public strsql1 As String = "select ID AS 序号,cyear as 年度,cmonth as 月份,hth as 合同号,sr as 销售收入,cmemo as 备注 from tb1 where cyear='" & Me.ComboBox1.Text & "' and cmonth='" & Me.ComboBox2.Text & "' order by hth"
Public sqldataadapter11 = New SqlClient.SqlDataAdapter(strsql1, sqlconnection1)
Public dataset1 As New DataSet
'读出数据到DataGridView1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
sqldataadapter11.Fill(dataset1, "table1")
Me.DataGridView1.DataSource = dataset1.Tables("table1")
’修改数据,更新表
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim MyCommandBuilder As New SqlClient.SqlCommandBuilder
MyCommandBuilder = New SqlClient.SqlCommandBuilder(sqldataadapter11)
sqldataadapter11.Update(dataset1, "table1")
dataset1.AcceptChanges()
DataGridView1.Update()
提示错误 对于不返回任何键列信息的 SelectCommand,不支持 UpdateCommand 的动态 SQL 生成