update table with c# and mysql

Question

i apologize in advance for the elementary questions

i am using:

command.CommandText = "select * from some_table;"

to retrieve data

can i do use the same thing to update data?

Jimmy W · Accepted Answer · 2010-04-27 00:31:53Z

1

I assume that command is an instance of SqlCommand. In which case, yes you can. Here is a code fragment detailing what you should do to update data:

command.Connection = (Insert connection string here);
command.CommandText = (Insert update statement);
int numRowsUpdated = command.ExecuteNonQuery();

As I type three answers came in. No need to apologize; we're happy to help!

answered Apr 27, 2010 at 0:31

Jimmy W

5393 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

amelvin · Accepted Answer · 2010-04-27 00:24:08Z

1

Here are some simple examples on reading and writing to a database.

answered Apr 27, 2010 at 0:24

amelvin

9,0714 gold badges40 silver badges59 bronze badges

Comments

Matthew Flaschen · Accepted Answer · 2010-04-27 00:24:29Z

1

There's a lot of ways, but one is to use a SQL update statement and parameterized statements.

answered Apr 27, 2010 at 0:24

Matthew Flaschen

286k53 gold badges523 silver badges554 bronze badges

Comments

Steven Dorfmeister · Accepted Answer · 2010-04-27 00:27:11Z

1

The above examples are great ones, you could also look at LINQ.

http://msdn.microsoft.com/en-us/library/bb399398.aspx

answered Apr 27, 2010 at 0:27

Steven Dorfmeister

2001 silver badge7 bronze badges

Collectives™ on Stack Overflow

update table with c# and mysql

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related