how to save textbox values to 2 tables using sqladapter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
=?Utf-8?B?TmV3YmVlIEFkYW0=?= said:
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/
 
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
 
Back
Top