26.12.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

Listing 26.12 Updating a SQL Server CE Database
private void btnChange_Click(object sender, System.EventArgs e)
{
DataGridCell currentCell;
string currentCellData;
// Get the text to put into the current cell.
currentCellData = tbNewValue.Text;
// Get the current cell.
currentCell = dataGrid1.CurrentCell;
// Set the current cell’s data.
dataGrid1[currentCell.RowNumber,currentCell.ColumnNumber] = currentCellData;
// update the data source
DataRow updateRow =
catalogDataSet.Tables[“Catalog”].Rows[dataGrid1.CurrentRowIndex];
updateRow[“Title”] = dataGrid1[dataGrid1.CurrentRowIndex,1];
updateRow[“Artist”] = dataGrid1[dataGrid1.CurrentRowIndex,2];
sqlDataAdapter.Update( catalogDataSet, “Catalog” );
}