Updating Grid view Data

Question

0.00/5 (No votes)

See more:

This is my code for updating and saving from grid view data directly.But it is not working.
Help me out to update record.thanks in advance.Where i am making mistake im not able to find out.

C#

protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
   {
       string id = gridRegistrationTableDetails.Rows[e.RowIndex].Cells[0].Text;
       string name=((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
       string address = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
       string dept = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
       string mail = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
       updaterecordMethod(name,address,dept,mail);
       gridRegistrationTableDetails.EditIndex = -1;
       BindData();
   }

   private void updaterecordMethod(string name,string address,string dept,string mail)
   {
       string UpdateQuery = "update SignUP set Employee_Name=@Empname,Employee_Address=@EmpAddress,Employee_Dept=@EmpDept,Employee_Mail=@EmpMail";
       try
       {
           SqlConObject.Open();
           SqlCommand cmd = new SqlCommand(UpdateQuery, SqlConObject);
           cmd.Parameters.AddWithValue("@Empname", name);
           cmd.Parameters.AddWithValue("@EmpAddress", address);
           cmd.Parameters.AddWithValue("@EmpDept", dept);
           cmd.Parameters.AddWithValue("@EmpMail", mail);
           cmd.CommandType = CommandType.Text;
           cmd.ExecuteNonQuery();
       }
       finally
       {
           SqlConObject.Close();
       }

   }

Posted 24-Jul-12 1:59am

ajithk444

Updated 24-Jul-12 2:00am

v2

Add a Solution

Comments

Prasad_Kulkarni 24-Jul-12 8:02am

Is it giving any error?
Have you tried using debugger??
..and what is condition for updating records? which record this query will update?

_Amy 24-Jul-12 8:03am

It is correct only.. What the error you are getting?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

AshishChaudha · Answer 1 · 2012-07-24T02:07:00

Please check out the Casting of the Gridview values. you are assigning values to string variable. I am sure you are getting error while building a page.

C#

protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
    {
        string id = gridRegistrationTableDetails.Rows[e.RowIndex].Cells[0].Text;
        Textbox name=((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        Textbox address = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        Textbox dept = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        Textbox mail = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        updaterecordMethod(name.Text.Trim(),address.Text.Trim(),dept.Text.Trim(),mail.Text.Trim());
        gridRegistrationTableDetails.EditIndex = -1;
        BindData();
    }

Try this

Thanks
Ashish

ajithk444 · Answer 2 · 2012-07-24T02:47:00

Solution 3

this code is not working Ashish..!

Posted 24-Jul-12 2:47am

ajithk444

ajithk444 · Answer 3 · 2012-07-24T20:48:00

i got it. this is the code....

C#

protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
    {
        string id = gridRegistrationTableDetails.Rows[e.RowIndex].Cells[2].Text;
        string name = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
        string address = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
        string dept = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[5].Controls[0]).Text;
        string mail = ((TextBox)gridRegistrationTableDetails.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
        updaterecordMethod(name, address, dept, mail);
        gridRegistrationTableDetails.EditIndex = -1;
        BindData();
    }
    private void updaterecordMethod(string name,string address,string dept,string mail)
    {
        string UpdateQuery = "update ISSSignUP set Employee_Name=@Empname,Employee_Address=@EmpAddress,Employee_Email=@EmpMail,Employee_Department=@EmpDept";
        try
        {
            SqlConObject.Open();
            SqlCommand cmd = new SqlCommand(UpdateQuery, SqlConObject);
            cmd.Parameters.AddWithValue("@Empname", name);
            cmd.Parameters.AddWithValue("@EmpAddress", address);
            cmd.Parameters.AddWithValue("@EmpMail", mail);
            cmd.Parameters.AddWithValue("@EmpDept", dept);
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();
        }
        finally
        {
            SqlConObject.Close();
        }

    }

Updating Grid view Data

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0