469,568 Members | 1,723 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

how to save textbox values to 2 tables using sqladapter

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)
--
Adam S
Jul 21 '05 #1
2 1820
"=?Utf-8?B?TmV3YmVlIEFkYW0=?=" <Ne********@discussions.microsoft.com> wrote in
news:B4**********************************@microsof t.com:
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/
Jul 21 '05 #2
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
Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.