Update existing info in db ?

[Pirate]

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

Thank you !

[Pirate]

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 ?

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

[Lethal]

You could use the Command object.

[Pirate]

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

[nswan]

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

[Pirate]

Yes , same record , same location .

[nswan]

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

[Pirate]

The link isn't working

[Pirate]

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

[nswan]

just coz i am stuck on that link i put up

[stingrae]

Pirate,

try this:

My eBook

any feedback would be appreciated too.

cheers

[Pirate]

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

[stingrae]

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