Update existing info in db ?

What object should I use along with Update SQL Statement to update my current record ?

Thank you !

This is the array , I use it to save data against database .
I wanna do the same ,edit these data , and push them all at once to database .Is it possible ?

VB Code:

Dim DataArry() As Object = {TextBox1.Text, TextBox2.Text, _ 
TextBox3.Text, TextBox4.Text, TextBox5.Text, TextBox6.Text, ComboBox1.Text, ComboBox2.Text, ComboBox3.Text}

You could use the Command object.

OK , How about SQL Statement that accepts string array to update all records ??
Thanks

are the controls going in the same record (i.e. same row, different columns) or are they going in a different row each?

Yes , same record , same location .

just do an insert query if it's a new record or an update if it is one that needs updating.
You could just use a command object for this like the person before said.


know anything about asp.net?

http://www.vbforums.com/showthread.p...hreadid=238352

The link isn't working ;)

No . I don't know about ASP.NET . Why?:rolleyes:

just coz i am stuck on that link i put up :(

Pirate,

try this:

My eBook

any feedback would be appreciated too.

cheers

That's cool stingrae . That would answer all database related question. Keep it up .:)

thaks pirate. i think i will now post so all can use.