black zero
Well-known member
- Joined
- Jan 15, 2009
- Messages
- 53
- Programming Experience
- Beginner
Like.. I recently started to learn about it, having been using archaic sql syntax for a long time. Apologize too if this sub forum isn't the most appropriate place for this thread, kindly move it if it is.
Firstly, I've reread this topic
http://www.vbdotnetforums.com/database-general-discussion/18562-ins-outs-parameterized-queries.html
Still, not even understand the slightest part, so... need a guidance to learn this new thing for me.
Assuming i have a table called 'Invoice'
And it has three columns - Invoice_number, invoice_date, total
And three textboxes on a form.
So the syntax would run like this?
Again, seems silly, but I really have no idea how it's working. Kindly explain it.
Firstly, I've reread this topic
http://www.vbdotnetforums.com/database-general-discussion/18562-ins-outs-parameterized-queries.html
Still, not even understand the slightest part, so... need a guidance to learn this new thing for me.
VB.NET:
"INSERT INTO table1 VALUES(@param1, @param2, @param3)"
Assuming i have a table called 'Invoice'
And it has three columns - Invoice_number, invoice_date, total
And three textboxes on a form.
So the syntax would run like this?
VB.NET:
"INSERT INTO Invoice VALUES(@textbox1.text, @textbox2.text, @textbox3.text)"
Again, seems silly, but I really have no idea how it's working. Kindly explain it.