Hi folks, I am building my update statement and was wondering if someone can help me with
what is between the *****************. So I can execute my update statement.
I would appreciate it. Any other information required please don't hesitate to send
me email.
private void DataGridUserManagementID_Update(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strUserID;
string strStoreID, strStore;
string strAccessLevelID, strAccessLevel;
string strUserName, strFullName;
string strReportToID, strReportTo;
// Declare Textboxes
// Gets the value of the key field of the row being updated
strUserID = ((Label)e.Item.FindControl("lblUserID")).Text;
strStoreID = ((DropDownList)(e.Item.FindControl("editStores"))).SelectedItem.Value;
strStore = ((DropDownList)(e.Item.FindControl("editStores"))).SelectedItem.Text;
strAccessLevelID = ((DropDownList)(e.Item.FindControl("editAccessLevels"))).SelectedItem.Value;
strAccessLevel = ((DropDownList)(e.Item.FindControl("editAccessLevels"))).SelectedItem.Text;
strReportToID = ((DropDownList)(e.Item.FindControl("editReportTo"))).SelectedItem.Value;
strReportTo = ((DropDownList)(e.Item.FindControl("editReportTo"))).SelectedItem.Text;
strUserName = ((TextBox)e.Item.FindControl("editUserName")).Text;
strFullName = ((TextBox)e.Item.FindControl("editFullName")).Text;
**************************
string commandString = "Update tbl_Users Set UserName = strUserName
FullName = strFullName
StoreID = strStoreID
AccessLevelID = strAccessLevelID
ReportToID= strReportToID
(where UserID = strUserID)";
ExecuteSQLStatement(commandString);
// Deselect Current Row for Editing
**************************
DataGridUserManagementID.EditItemIndex = -1;
BindData();
}