Database

public void Edit_User(object sender, DataListCommandEventArgs e)<br />
		{<br />
			userList.EditItemIndex = e.Item.ItemIndex;<br />
			userList.DataBind();<br />
		}<br />
<br />
		public void Update_User(object sender, DataListCommandEventArgs e)<br />
		{<br />
			string txtCustFirstNameEdit = ((TextBox)e.Item.FindControl("txtUserFirstNameEdit")).Text;<br />
			string UserKey = userList.DataKeys[e.Item.ItemIndex].ToString();<br />
			<br />
			message.Text = UserKey;<br />
			message1.Text = txtCustFirstNameEdit;<br />
			<br />
			OleDbConnection userListConnection = new OleDbConnection(@.....");<br />
<br />
			//StringBuilder custUpdateBuild = new StringBuilder();<br />
			//custUpdateBuild.Append("UPDATE custInfo SET custFirstName = ('");<br />
			//custUpdateBuild.Append(txtCustFirstNameEdit);<br />
			//custUpdateBuild.Append("') WHERE ID= ('");<br />
			//custUpdateBuild.Append(UserKey);<br />
			//custUpdateBuild.Append("')");<br />
			//string oleUpdateString = custUpdateBuild.ToString();<br />
<br />
			string oleUpdateString = "UPDATE custinfo SET custFirstName = "+"'"+txtCustFirstNameEdit+"'";<br />
			oleUpdateString += " WHERE ID = " + UserKey;<br />
			OleDbDataAdapter userUpdateAdapter = new OleDbDataAdapter();<br />
			userUpdateAdapter.UpdateCommand = new OleDbCommand(oleUpdateString, userListConnection);<br />
			userListConnection.Open();<br />
			userUpdateAdapter.Update(userListDataSet, "custInfo");<br />
			userListConnection.Close();<br />
<br />
			userList.EditItemIndex = -1;<br />
			userList.DataBind();<br />
<br />
			<br />
		}