edit and update complete
-
<%@ 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 userId = ((TextBox)e.Item.Cells[1].Controls[0]).Text; string updateCmd = "Update users set upassword = @password, fname = @fname, lname = @lname, address = @address WHERE username = '"+ userId + "'"; //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; try { Response.Write(OleDbCom.CommandText); Response.Write("<br>"); //Response.Write("<br>uid = " + OleDbCom.Parameters["@uid"].Value); Response.Write("<br>password = " + OleDbCom.Parameters["</x-turndown>
-
<%@ 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 userId = ((TextBox)e.Item.Cells[1].Controls[0]).Text; string updateCmd = "Update users set upassword = @password, fname = @fname, lname = @lname, address = @address WHERE username = '"+ userId + "'"; //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; try { Response.Write(OleDbCom.CommandText); Response.Write("<br>"); //Response.Write("<br>uid = " + OleDbCom.Parameters["@uid"].Value); Response.Write("<br>password = " + OleDbCom.Parameters["</x-turndown>
That's a block of code. What is your question?
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!