May 2, 2002 at 3:11 pm
I am developing a manufacturing application using VB6 to SQL 2000 on Windows 2000 Sever. My common theme is a form with text fields linked by a common ID to a grid (MSFlexGrid ) and I am running into a lot of issues on developing this. Would this be the place to discuss this and where might I find some examples?
I am new to SQL Server but have developed the application in MS Access and VBA. My first cut at adding new records from the grid with a stored procedure is requiring me to execute the SP for each row. This seems inefficient and will cause a lot of network traffic and I know that there must be a better way.
Looking for help and some example code.
May 2, 2002 at 3:18 pm
You can pass all your parameters to the back end and process them there.
There are different ways to process multiple sets of parameters, one of them
I showed in the script "Pass several sets of parameters to run stored proc"
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=232
May 2, 2002 at 3:21 pm
You can usually find good examples at http://www.planet-source-code.com .
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 2, 2002 at 4:10 pm
We dont mind trying to assist with the theory part anyway, sometimes you'll be better off visiting a VB specific site. You can bind the grid to a recordset at runtime or design time, generally you'd use a stored proc to fill the recordset, then bind it.
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply