How to bind data from gridview link button to form ctrls ?

Nag J

i want to bind data from gridview eidt link button to form controls which contains textboxes and dropdownlists for updating data .(not inside gridview control)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano7y ago
@Sonu Gupta - your code below might not work.
con.Open();

SqlCommand cmd = new SqlCommand("Update UserDetails SET IsActive=’Yes’ where UserId="+userid,con);

int result=cmd.ExecuteNonQuery();

con.Close();
First, your variable con was never declared.
Second, you should wrap your code that eats resources such as SqlConnection and SqlCommand inside a using statement so object will be properly disposed after being used.
Finally, you should never append the value directly to your SQL statements as it can leads you to SQL Injection attack. You should use parameterize query to avoid that. Read: https://www.c-sharpcorner.com/article/protect-your-data-prevent-sql-injection/
0
Sonu Gupta7y ago
Hi,

Use like this -

Design View -

Edit User

Code view –

protected void lnkEdit_Click(object sender, EventArgs e)

{

LinkButton lnkEditbtn = sender as LinkButton;

GridViewRow gvrow = lnkEditbtn.NamingContainer as GridViewRow;

int userid = Convert.ToInt32(gdvRecords.DataKeys[gvrow.RowIndex].Value.ToString());

string username = gvrow.Cells[0].Text;

con.Open();

SqlCommand cmd = new SqlCommand("Update UserDetails SET IsActive=’Yes’ where UserId="+userid,con);

int result=cmd.ExecuteNonQuery();

con.Close();

}

-1
Vincent Maverick Durano7y ago
If you are not editing data within the GridView then just use a TemplateField column and add a LinkButton/Button there. Then you can do something like this to get the row values when clicking the button:
protected void lnkEdit_Click(object sender, EventArgs e)
{
        LinkButton lb = (LinkButton)sender;
        GridViewRow row = (GridViewRow)lb.NamingContainer;
        if (row != null)
        {
            //gets the row index selected
            int index = row.RowIndex;

            //gets the datakey
            string itemID = GridView1.DataKeys(index).Value.ToString();

            //access row values and assign it to your TextBox
            TextBox1.Text = row.Cells[0].Text;
            TextBox2.Text = row.Cells[1].Text;

            //If you are using TemplateField then you can access them using FindControl() method

            TextBox3.Text = ((TextBox)row.FindControl("YourTextBoxIDFromGridViewRow")).Text;
        }
}
0