Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Looping Insert Stored Procedure in VB

Author  Topic 

NoviceIT_GUY
Starting Member

2 Posts

Posted - 2003-01-30 : 17:52:46
Dear Friends,

I know its an elementary topic for most of the people , but i am new to programming. So I want to learn.
How do I pass values of( textBox fields) from my my form i have created in VB and pass the values to a Insert stored procedure and loop it several time, the values should not change , it should just insert the values collected again and again & insert the values collected into the appropriate fields in the database. Any sample code will be appreciated.

Thanks



Edited by - NoviceIT_GUY on 01/30/2003 17:54:21

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-30 : 18:20:26
Start Here.
http://www.asp101.com/articles/wrox/asp30/26100903.asp

Then do a search on forum for ADO Command.

An easy guide to vb looping constructs
http://www.vbtutor.net/lesson9.html



Edited by - ValterBorges on 01/30/2003 18:20:41
Go to Top of Page

NoviceIT_GUY
Starting Member

2 Posts

Posted - 2003-01-30 : 21:25:54
Can these examples be used in VB.NET and SQL SERV 2000 ?

Go to Top of Page

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-30 : 22:48:32
Need ADO.NET AND VB.NET
http://www.dotnet247.com/247reference/guide/18.aspx

http://www.sql-server-performance.com/ado_net_performance.asp

Go to Top of Page
   

- Advertisement -