Problem in Edit and update access
-
my all code is running fine, but when i click on the update link ... it does not update the record :doh: ... need professional:cool: help on this because the compiler did't show me any error ... my all code is as under... ------------------------------------------------------- <%@ Page Language="C#" Debug="True" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> // Insert page code here OleDbConnection oledbCon; void Page_Load(Object sender, EventArgs e) { OleDbConnection oledbcon = new OleDbConnection("Provider = Microsoft.Jet.Oledb.4.0; Data Source=d:\\access1.mdb"); if(!IsPostBack) BindGrid(); } public void dg_Edit(Object sender, DataGridCommandEventArgs e) { dg.Columns[0].HeaderText="Edit"; dg.EditItemIndex = (int)e.Item.ItemIndex; BindGrid(); } public void dg_Cancel(Object sender, DataGridCommandEventArgs e) { dg.Columns[0].HeaderText="Cancel"; dg.EditItemIndex = -1; BindGrid(); } public void dg_Update(Object sender, DataGridCommandEventArgs e) { OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jet.Oledb.4.0; Data Source=d:\\access1.mdb"); dg.Columns[0].HeaderText="Update"; string updateCmd = "Update users set upassword = @password, fname = @fname, lname = @lname, address = @address WHERE username = @uid"; OleDbCommand OleDbCom = new OleDbCommand(updateCmd, oledbCon); OleDbCom.Parameters.Add(new OleDbParameter("@uid",OleDbType.VarChar, 50)); OleDbCom.Parameters.Add(new OleDbParameter("@password",OleDbType.VarChar, 50)); OleDbCom.Parameters.Add(new OleDbParameter("@fname",OleDbType.VarChar, 50)); OleDbCom.Parameters.Add(new OleDbParameter("@lname",OleDbType.VarChar, 50)); OleDbCom.Parameters.Add(new OleDbParameter("@address",OleDbType.VarChar, 50)); OleDbCom.Parameters["@uid"].Value=((TextBox)e.Item.Cells[1].Controls[0]).Text; OleDbCom.Parameters["@password"].Value=((TextBox)e.Item.Cells[2].Controls[0]).Text; OleDbCom.Parameters["@fname"].Value=((TextBox)e.Item.Cells[3].Controls[0]).Text; OleDbCom.Parameters["@lname"].Value=((TextBox)e.Item.Cells[4].Controls[0]).Text; OleDbCom.Parameters["@address"].Value=((TextBox)e.Item.Cells[5].Controls[0]).Text; OleDbCom.Connection.Open(); try { OleDbCom.ExecuteNonQuery(); Response.Writ</x-turndown>