uSerTable = New DataTable
uSerDataset = New DataSet
SQLString = "select * from a001 where aa1='"&Trim (txt_aa1.Text) & "'"
fLAdapter = New SqlDataAdapter(SQLString, mconn)
fLAdapter.FillSchema(uSerDataset, SchemaType.Source, "a001")
fLAdapter.Fill(uSerDataset, "a001")
uSerTable = uSerDataset.Tables("a001")
uSerTable.PrimaryKey = New DataColumn() {uSerTable.Columns("aa1")}
使用SqlCommandBuilder自動生成update語句,更新時,總是說selectcommand 不支援 updatecommand , PrimaryKey就在那里設置
uSerDataset = New DataSet
SQLString = "select * from a001 where aa1='"&Trim (txt_aa1.Text) & "'"
fLAdapter = New SqlDataAdapter(SQLString, mconn)
fLAdapter.FillSchema(uSerDataset, SchemaType.Source, "a001")
fLAdapter.Fill(uSerDataset, "a001")
uSerTable = uSerDataset.Tables("a001")
uSerTable.PrimaryKey = New DataColumn() {uSerTable.Columns("aa1")}
使用SqlCommandBuilder自動生成update語句,更新時,總是說selectcommand 不支援 updatecommand , PrimaryKey就在那里設置
"select * from a001"
重新生成UpdateCommand