Updating through gridview doesn't works

Please use SqlCommandBuilder Class to update the data in DataGridView.

Please resolve my query. Ty

Can you paste your error. I didn't understand your question completely

Ty very much .But i am getting this error now : 'ddlDepartment' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value But my dropwdownlist is populated. What the error mean. Ty

Hi Rajeev, This is coding and i have put datakeynames - id protected void GridView_Updating(object sender, GridViewUpdateEventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=SONY-VAIO\SQLEXPRESS;Initial Catalog=Employee;Integrated Security=True"); con.Open(); Label lb = (Label)GridView.Rows[e.RowIndex].FindControl("Id"); RadioButtonList rd = (RadioButtonList)GridView.Rows[e.RowIndex].FindControl("rdStatus"); CheckBoxList cb = (CheckBoxList)GridView.Rows[e.RowIndex].FindControl("ChkActive"); TextBox tx1 = (TextBox)GridView.Rows[e.RowIndex].FindControl("txtId"); TextBox tx2 = (TextBox)GridView.Rows[e.RowIndex].FindControl("txtName"); TextBox tx3= (TextBox)GridView.Rows[e.RowIndex].FindControl("txtAddress"); DropDownList ddl = (DropDownList)GridView.Rows[e.RowIndex].FindControl("ddlDepartment"); SqlCommand cmd = new SqlCommand("Update Edittable set Name=@Name , Address=@Address,Status=@Status,Active=@Active,Department=@Department,Salary=@Salary WHERE Id=@Id", con); cmd.Parameters.AddWithValue("@Id", txtId.Text.ToString()); cmd.Parameters.AddWithValue("@Name", txtName.Text.ToString()); cmd.Parameters.AddWithValue("@Address", txtAddress.Text.ToString()); cmd.Parameters.AddWithValue("@Department", ddlDepartment.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@Salary", txtSalary.Text.ToString()); cmd.Parameters.AddWithValue("@Active", ChkActive.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@Status", rdStatus.SelectedValue.ToString()); cmd.ExecuteNonQuery(); GridView.EditIndex = -1; FillGridView(); } i am getting this error Must declare the scalar variable "@Id". Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Id". The error is

Please update

Awaitng your reply. Rajeev Ty

i am getting this error Must declare the scalar variable "@Id". Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Id".