C#

... "VALUES ('" + username.UserName+ "','" + username.Password + "')";

<br />
private void updateButton_Click(object sender, System.EventArgs e)<br />
{<br />
//DataGridTableStyle provides the mechanisms<br />
DataGridTableStyle ts1 = new DataGridTableStyle();<br />
<br />
//DataGridCell allows you to hold the contents of the specified cell<br />
DataGridCell myCell;<br />
myCell = UserdataGrid.CurrentCell;<br />
<br />
// map the DataGridTableStyle object to the database source <br />
ts1.MappingName = "SessionTable";<br />
<br />
//Add the DataGridTableStyle object to the grid's TableStyles collection<br />
UserdataGrid.TableStyles.Add(ts1);<br />
<br />
string infoStr = null;<br />
int j = 0;<br />
<br />
//The two foreach statements is a loop within a loop<br />
//The outer loop deals with the row index<br />
//The inner loop returns the column number (j) if there is a match<br />
//and the infoStr(column to change)<br />
foreach(DataGridTableStyle gridStyle in UserdataGrid.TableStyles)<br />
{<br />
<br />
foreach(DataGridColumnStyle colStyle in gridStyle.GridColumnStyles)<br />
{<br />
if (j == myCell.ColumnNumber)<br />
{<br />
infoStr = colStyle.MappingName;<br />
}<br />
j++;<br />
}<br />
//end inner foreach<br />
}<br />
//end outer foreach<br />
<br />
//The element selection has been found <br />
//and the current row index is where it can be found	<br />
int i = UserdataGrid.CurrentRowIndex;<br />
<br />
//Get the unique id associated with this row<br />
//Note that I needed to make this GUID id part of <br />
//my DataTable so that when I update the sql table<br />
//I am updating only that particular record<br />
//and not other records that may have similiar entries<br />
String userId = UserdataGrid[i, 7].ToString();<br />
<br />
//The UpdateRecord method creates an SQL update statement<br />
//Parameters are:<br />
//Table to change<br />
//Column to change<br />
//Column to search for GUID id<br />
//match on GUID id will determine row index<br />
//Value to update<br />
sql.UpdateRecord("SessionTable", infoStr, "UserId", userId, UserdataGrid[myCell].ToString());<br />
<br />
//Now all we need to do is show the changes in the DataGrid<br />
FillData();<br />
UserdataGrid.SetDataBinding(dataSet, "SessionTable");<br />
UserdataGrid.Refresh();<br />
}<br />
<br />