2 replies to this topic

[Tonchi]

can someone give me an example for using Update statement...I have one dataGridView control with one column and x rows...after I click Update button than I want to update that table into my database
how should my query looks like if it is non static?

[gregwarner]

UPDATE `tbl_name` SET `col_name`=[I](some value)[/I] [ , `another_col_name`=[I](some value)[/I] ] WHERE `id_col_name`=(some id value);

That what you're looking for?

Here's the full UPDATE syntax documentation:
MySQL :: MySQL 5.0 Reference Manual :: 12.2.10 UPDATE Syntax

[Tonchi]

i know the syntax but what i'm trying to do here is not that...i don't know how to explain so i will give you my project here and then you will know what i need
[ATTACH]4187[/ATTACH]
now open the solution file and debbug that project and when you will be in program click on update button and you will see my problem

Attached Files

•  Database1.zip   119.86K   16 downloads