Click here to Skip to main content
12,758,462 members (30,326 online)
Rate this:
Please Sign up or sign in to vote.
See more: ASP.NET

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;");
        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;

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


Posted 28-Nov-12 20:30pm
Updated 28-Nov-12 20:32pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 29 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100