how to save textbox values to 2 tables using sqladapter

[Guest]

how to save textbox values to 2 tables using sqladapter


I am new with this. Do I need to ADO.net?
what is the simplist correct way?

or can I write a query in my vb.net form

insert table Machine_Count(MachName, CoinsIn)
values(txtMachineName(1).Text, txtCoinsIn(1).Text)

insert table Location_Count(Location_Name, Date,Total)
values(cboLocation.ItemSelected,lblDate.text, lblTotal.Text)

 

[Chad Z. Hower aka Kudzu]

how to save textbox values to 2 tables using sqladapter

I am new with this. Do I need to ADO.net?
Yes.

what is the simplist correct way?

Well ADO.NET is not simple, even the simple ways require some work. Check MSDN, there are a
lot of articles on using ADO.NET with plenty of example.

or can I write a query in my vb.net form

insert table Machine_Count(MachName, CoinsIn)
values(txtMachineName(1).Text, txtCoinsIn(1).Text)

insert table Location_Count(Location_Name, Date,Total)
values(cboLocation.ItemSelected,lblDate.text, lblTotal.Text)

You can yes if you dont care about databinding etc.


--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Develop ASP.NET applications easier and in less time:
http://www.atozed.com/IntraWeb/

 

[Cor Ligthert]

Newbee,

how to save textbox values to 2 tables using sqladapter

Although it is not direct related, because of the purpose I saw that you
needed it for, use databinding.

(And than don't forget than that with databinding data is not always
directly placed in the binded datasource, they are binded).

Cor