Cannot Update Database through DataGrid & DataList Control

[tjc0ol]

Hi guys,
Im just wondering that I cannot update my database throught datagrid datalist control, and the only thing works is that I can delete, cancel, edit but when I clicked update link there's an error that says: "Syntax error in UPDATE statement."

I wonder what's wrong with my code and how to correct this one?

Below are my codes:

OleDbConnection objConn = new OleDbConnection(
	"Provider=Microsoft.Jet.OleDb.4.0;" +
	"Data Source=D:\\ASPX\\" + 
	"data-x.mdb");
OleDbCommand objCmd;
OleDbDataReader objRdr;
String strCmd;

void Page_Load() {
	if (!IsPostBack) {
	  BindData();
    }
}
void BindData() {
	objConn.Open();
	if (Request.QueryString["id"] != null) {
		objCmd = new OleDbCommand(
			"SELECT * FROM Employees WHERE EmployeeID=" + 
			Request.QueryString["id"], objConn);
		objRdr = objCmd.ExecuteReader();
		dgAddressBookDetails.DataSource = objRdr;
		dgAddressBookDetails.DataBind();
	}	else {
		objCmd = new OleDbCommand("SELECT * FROM Employees", objConn);
		objRdr = objCmd.ExecuteReader();
		dgAddressBook.DataSource = objRdr;
		dgAddressBook.DataBind();
	}
		objRdr.Close();
		objConn.Close();
}
void dg_Edit(Object s, DataGridCommandEventArgs e) {
	dgAddressBook.EditItemIndex = e.Item.ItemIndex;
	BindData();
}
void dg_Cancel(Object s, DataGridCommandEventArgs e) {
	dgAddressBook.EditItemIndex = -1;
	BindData();
}
void dg_Update(Object s, DataGridCommandEventArgs e) {
	int intEmployeeID;
	String strName, strExtension;

	intEmployeeID = (int)dgAddressBook.DataKeys[e.Item.ItemIndex];
	strName = ((TextBox)e.Item.FindControl("txtName")).Text;
	
	strCmd = "UPDATE Employees SET Name=@Name, " +
		"WHERE EmployeeID=@EmployeeID";
	objCmd = new OleDbCommand(strCmd, objConn);
	objCmd.Parameters.Add("@Name", strName);
	objCmd.Parameters.Add("@EmployeeID", intEmployeeID);
	
	objConn.Open();
	objCmd.ExecuteNonQuery();
	objConn.Close();
	
	dgAddressBook.EditItemIndex = -1;
	BindData();
}
void dg_Delete(Object s, DataGridCommandEventArgs e) {
	int intEmployeeID;
	
	intEmployeeID = (int)dgAddressBook.DataKeys[e.Item.ItemIndex];
	
	strCmd = "DELETE FROM Employees WHERE EmployeeID=@EmployeeID";
	objCmd = new OleDbCommand(strCmd, objConn);
	objCmd.Parameters.Add("@EmployeeID", intEmployeeID);
	
	objConn.Open();
	objCmd.ExecuteNonQuery();
	objConn.Close();
	
	dgAddressBook.EditItemIndex = -1;
	BindData();
}

And my DataGrid settings below:

<asp:DataGrid id="dgAddressBook" runat="server" AutoGenerateColumns="False" CellPadding="4" GridLines="None" OnEditCommand="dg_Edit" OnCancelCommand="dg_Cancel" OnUpdateCommand="dg_Update" OnDeleteCommand="dg_Delete" DataKeyField="EmployeeID">
		<ItemStyle Font-Names="Arial" Font-Size="Smaller" ForeColor="#000000" />
		<HeaderStyle Font-Names="Arial" Font-Size="Smaller" Font-Bold="true" ForeColor="#FFFFFF" BackColor="#003366" />
 		<AlternatingItemStyle Font-Names="Arial" Font-Size="Smaller" BackColor="#CCCCCC" />
 		<Columns>
		<asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" />
		<asp:TemplateColumn>
		<HeaderTemplate>Name</HeaderTemplate>
		<ItemTemplate><%# DataBinder.Eval(Container.DataItem, "Name") %></ItemTemplate>
		<EditItemTemplate>
			<asp:TextBox ID="txtName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Name") %>' />
			<asp:RequiredFieldValidator ID="rfvName" Display="Dynamic" ErrorMessage="Name is required!" ControlToValidate="txtName" runat="server" />
		</EditItemTemplate>
		</asp:TemplateColumn>
		<asp:BoundColumn DataField="Extension" HeaderText="Extension" ReadOnly="true" />
		<asp:ButtonColumn ButtonType="LinkButton" Text="Delete" CommandName="Delete" />
 		</Columns>
 		</asp:DataGrid>

Hope to hear from you guys, thanks in advance. -Tj

[r035198x]

 	
	strCmd = "UPDATE Employees SET Name=@Name, " +
		"WHERE EmployeeID=@EmployeeID";

You do have an error in your update statement. That comma after @Name should not be there.

[tjc0ol]

A million thanks ;-)