How can I update all records in the database?

Question

2.33/5 (2 votes)

See more:

SQL-Server-2008R2

I have a grid view and an update button outside the grid view. When the user make some changes to the records inside the grid view,the records in the database will also be updated.
Here's my code:

C#

protected void Button2_Click(object sender, EventArgs e)
   {
       string connectionString = "Server=192.168.100.252;Database=AMICASSA_Checklist;Trusted_Connection=true";

       SqlConnection myConnection = new SqlConnection(connectionString);
       myConnection.Open();
       SqlCommand cmd = new SqlCommand("UPDATE Sample ", myConnection);
       SqlDataReader red = cmd.ExecuteReader();
       red.Close();
       myConnection.Close();
       BindData();

   }

Can Anyone help me?

Posted 3-Aug-14 21:03pm

DarkDreamer08

Updated 3-Aug-14 21:20pm

Thanks7872

v2

Add a Solution

Comments

SRK90 4-Aug-14 3:08am

I dont see you are passing any value to your database. if i am right, then your database procedure should have parameters. So you have to pass those parameters from here.

DarkDreamer08 4-Aug-14 3:13am

i do not put parameters inside my query because there is no specific row that the user will change the record.the user can change what ever they like in any rows. That is why my query is like that. Is that possible to update the database after changing all the records and clicking the update button outside the grid view? Is there any way to do that?

SRK90 4-Aug-14 3:17am

else put all the changes in session while the user do the changes in grid view and get the values from session after the button click and then clear the session.

u mani 4-Aug-14 3:13am

if u want to update every record then write the update query in loop .. then it will update every record . .

DarkDreamer08 4-Aug-14 3:22am

what do you mean by that? could you show me a sample- a bit of codes? I mean not totally all the codes. Let me do that. so that I can get what you want me to do :) Thanks

Maciej Los 4-Aug-14 3:25am

Not enough information. Provide more details about data binding.

[no name] 5-Aug-14 1:19am

SqlCommand cmd = new SqlCommand("UPDATE Sample ", myConnection);

Your command text is incomplete. What exactly you need to update? You need to the command text something like this
SqlCommand cmd = new SqlCommand("UPDATE Sample set samplecode="+yourvalue , myConnection);
cmd.CommandType = CommandType.Text;

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)

Maciej Los · Answer 1 · 2014-08-03T21:28:00

Solution 1

Please, read my comment to the question.

Have a look here: Updating Data Sources with DataAdapters[^]
If you would like to update data using sql statement, you should use UPDATE[^] statement.

Posted 3-Aug-14 21:28pm

Maciej Los

Sibeesh Venu · Answer 2 · 2014-08-04T19:27:00

SqlCommand cmd = new SqlCommand("UPDATE Sample ", myConnection);

Your command text is incomplete. What exactly you need to update? You need to use the command text something like this

SQL

SqlConnection myConnection = new SqlConnection(connectionString);
        myConnection.Open();
        SqlCommand cmd = new SqlCommand("UPDATE Sample set    
                                samplecode="+yourvalue , myConnection);

        cmd.CommandType = CommandType.Text;

Divya RS · Answer 3 · 2014-08-04T20:08:00

Solution 3

Bulk Update using Sql Merge will be useful for you
Try with it
upsert to sql[^]
Merge in Sql[^]
bulk upsert to sql server[^]

Posted 4-Aug-14 20:08pm

Divya RS