C#

<br />
public void Page_Load(Object sender, EventArgs e)<br />
{ <br />
_sqlStmt = "SELECT Nm as [Name], OfficeNm as [Office Name], HomePhone as Home, OfficePhone as Office, Address FROM contacts";<br />
oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\\db.mdb";<br />
oleDbDataAdapter1.SelectCommand.CommandText = _sqlStmt;<br />
dataSet1.Clear();<br />
oleDbDataAdapter1.Fill(dataSet1, "Contacts");<br />
BindGrid();<br />
}<br />
<br />
<br />
void BindGrid()<br />
{<br />
	Trace.Write ("**IN_BindGrid");<br />
	MyDataGrid.DataSource = dataSet1.Tables["Contacts"].DefaultView;<br />
	MyDataGrid.DataBind();<br />
}<br />
<br />
<br />
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e) <br />
{<br />
	Trace.Write ("**In_MyDataGrid_Update");<br />
	// For bound columns the edited value is stored in a textbox,<br />
	// and the textbox is the 0th element in the column's cell<br />
	string Name = ((TextBox)e.Item.Cells[1].Controls[0]).Text;<br />
	string OfficeNm = ((TextBox)e.Item.Cells[2].Controls[0]).Text;<br />
	string Home = ((TextBox)e.Item.Cells[3].Controls[0]).Text;<br />
	string Office = ((TextBox)e.Item.Cells[4].Controls[0]).Text;<br />
	string Address = ((TextBox)e.Item.Cells[5].Controls[0]).Text;<br />
<br />
        // Perform the update.<br />
	//sqlDataAdapter1.Update(ds);<br />
	oleDbDataAdapter1.Update(dataSet1);<br />
	// Reload the grid.<br />
	BindGrid();<br />
}<br />
 <br />