How to Update, Insert, Gridview Values to SQl DB

See more:

ASP.NET

Hi,

Am unable to Update and Insert the values from Gridview, so please anybody can help me to solve this problem.

Here is My Source C# Code, and i will post my Source code in nex page.

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

        var EmpNo = GridView1.DataKeys[e.RowIndex].Value;
        //GridViewRow row = GridView1.Rows[e.RowIndex] as GridViewRow;
        //TextBox EmpNo = GridView1.FooterRow.FindControl("txtEmpNo") as TextBox;
        TextBox EmpName = GridView1.FooterRow.FindControl("txtEmpName") as TextBox;
        DropDownList Designation = GridView1.FooterRow.FindControl("dropDesg") as DropDownList;
        DropDownList Department = GridView1.FooterRow.FindControl("ddlDep") as DropDownList;
        TextBox Salary = GridView1.FooterRow.FindControl("txtSal") as TextBox;
        int test = 0;
        int.TryParse(Salary.Text, out test);
        RadioButtonList Gender = GridView1.FooterRow.FindControl("RBLGender") as RadioButtonList;
        CheckBoxList Preference = GridView1.FooterRow.FindControl("CheckBoxList1") as CheckBoxList;

        SqlConnection con = new SqlConnection("Server=****;uid=sa;password=*****; database=sreeramdasari;");
        //con.Open();
        SqlCommand cmd = new SqlCommand("Update EmployeeDetails set EmpName=@EmpName, Designation=@Designation,Department=@Department,Salary=@Salary,Gender=@Gender,Preference=@Preference where EmpNo=@EmpNo");

        cmd.Parameters.AddWithValue("@EmpNo", EmpNo);
        cmd.Parameters.AddWithValue("@EmpName", EmpName.Text.Trim());
        cmd.Parameters.AddWithValue("@Designation", Designation.Text.Trim());
        cmd.Parameters.AddWithValue("@Department", Department.Text.Trim());
        cmd.Parameters.AddWithValue("@Salary", Salary.Text.Trim());
        cmd.Parameters.AddWithValue("@Gender", Gender.Text.Trim());
        cmd.Parameters.AddWithValue("@Preference", Preference.Text.Trim());
        cmd.Connection = con;
        con.Open();
        cmd.ExecuteNonQuery();




        lbl1.Text = (" Record Updated Successfully");
        //Label6.Enabled = true;
        GridView1.EditIndex = -1;
   
   

        con.Close();
        this.BindGridView();
   

    }