Hi
I've GrideView has (CRUD) operation using SQLDATASOURCE tool to connect with table, I'm trying to update some columns by rowcommand , but still updating get the value from controls in gridview.
See that code below
SQLDATACOURCE in code:
- SelectCommand="SELECT [Id], [P_Name] WHERE ([Id] = @Id)"
- UpdateCommand="UPDATE [Products] SET [P_Name] = @P_Name WHERE [Id] = @Id">
GRIDVIEW Code
Code behind code :
- protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
- {
- using (SqlConnection sqlcon = new SqlConnection(connectionString))
- if (e.CommandName == "Update")
- {
- try
- {
- GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
- int rowid = gvr.RowIndex;
- //Open Connection with D.B
- sqlcon.Open();
- string query = "UPDATE Products SET P_Name = @P_Name WHERE (Id = @Id)";
- {
- SqlCommand sqlcmd = new SqlCommand(query, sqlcon);
- sqlcmd.Parameters.AddWithValue("@P_Name", "A1");
- //=============================================
- //I Disabled that row just to check if update table is working by add last value "A1", but still get it from textbox
- //sqlcmd.Parameters.AddWithValue("@P_Name", (GridView1.Rows[rowid].FindControl("TB_NameE") as TextBox).Text);
- sqlcmd.Parameters.AddWithValue("@Id", Convert.ToInt32(GridView1.DataKeys[rowid].Value.ToString()));
- sqlcmd.ExecuteNonQuery();
- GridView1.EditIndex = -1;
- GridView1.DataBind();
- }
- }//End Try
- catch (Exception ex)
- {
- LBgvFi.Text = ex.Message;
- }
- }
- }
my question is: what is a first a priority?
1) textbox has DataBind("Name");
Or
2) Codebehind in c#
but why is still update a column by Textbox value. Until if I implement it by rowcommand event.
Thanks
Jenith ThakkarPosted Jul 9, 2020, 12:55 AM
Check marked lines
Aktham MahmoudPosted Jul 9, 2020, 12:50 AM
Jenith ThakkarPosted Jul 9, 2020, 12:33 AM