各位前辈,我在做DataAdapter.Update()时,出现问题了,以前在VS2003里是这样实现将当前行向下移一行:
int row = this.dataGrid1.CurrentCell.RowNumber;
this.dataGrid1.CurrentCell = new DataGridCell(row + 1, 0);而在2005里上面的语句是错误的,我又改为如下写法,还是不正确,请问,我该怎么写?DataTable myTable = new DataTable();
myTable.Rows.Add();
int row = this.dataGrid1.CurrentCell.RowNumber;
this.dataGrid1.CurrentCell = new DataGridCell(row + 1, 0);而在2005里上面的语句是错误的,我又改为如下写法,还是不正确,请问,我该怎么写?DataTable myTable = new DataTable();
myTable.Rows.Add();
Dim cmdbuider As New SqlClient.SqlCommandBuilder(adapter) Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand(sqlstr)
cmd.Connection = sqlcon
adapter.SelectCommand = cmd
adapter.SelectCommand.Connection = cmd.Connection adapter.UpdateCommand = cmdbuider.GetUpdateCommand
adapter.InsertCommand = cmdbuider.GetInsertCommand
adapter.UpdateCommand = cmdbuider.GetUpdateCommand
adapter.Update(dt) update = False
Me.BtnSave.Enabled = False
Me.BtnUpdate.Enabled = True