update values from gridview to database

Question

0.00/5 (No votes)

See more:

I have gridview in my page and it shows the datas from the database.

My question is if I update any values inside the database it must be updated in my database.

I tried many times but its not updating.

Posted 22-Feb-11 23:53pm

shanthikalai

Updated 23-Feb-11 0:37am

Dalek Dave

v3

Add a Solution

Comments

DaveAuld 23-Feb-11 6:05am

Does it throw any errors? are you actually performing an update/commit against the datasource? What code are you using to do the update?

shanthikalai 23-Feb-11 6:28am

con.Open();
MySqlCommand cmd = new MySqlCommand("update exam set name1=@name,ques=@ques where id = @id", con);
cmd.CommandType = CommandType.Text;
TextBox name = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].FindControl("name");
TextBox ques = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].FindControl("ques");
cmd.Parameters.Add("@name", MySqlDbType.VarChar).Value = name.Text;
cmd.Parameters.Add("@ques", MySqlDbType.VarChar).Value = ques.Text;
cmd.Parameters.Add("@id", MySqlDbType.Int16).Value = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;

this is my coding...

Dalek Dave 23-Feb-11 6:38am

Edited for Grammar and Readability.

2 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)

Ramalinga Koushik · Answer 1 · 2011-02-23T00:12:00

Solution 1

Hope data-gridview-edit-delete-update-C-net[^]this might help you.

Posted 23-Feb-11 0:12am

Ramalinga Koushik

**R. Giskard Reventlov** · Answer 2 · 2011-02-23T00:16:00

Do you mean to update the values that you have changed in the GridView back to the database? If that is what you meant then you need to create an event that will do this for you otherwise how does the program know that it should do something?

The simplest way to get you going is to drop a button on the page and create an event for it. Once you have changed data in the grid the button needs to be pressed to kick off the event. Inside the event you need to get all of the data and pass it back to the database. Since you have initiated a PostBack the page will refresh and, if you have properly bound the control, the new data should appear. As I said, that is very simplistic but should get you started - once you are comfortable with and understand this you can add sophistication to your code. Give it a try and if you get stuck ask another question.