Passing Multiple Records From VB To SQL

[chrisli888]

I have a VB application to connect to SQL Server 2000. I want to pass data of multiple records from
VB to SQL. The VB app has a grid that user enter infomation to. The VB appl does not have a constant
connection to the database. Therefore, the grid is not bound to a table. Furthermore, the grid contain
information that need to update several tables. I want to the form pass the grid information to the
SQL with just one trip to the database. How can I do it?

It is easy to pass data from one vb app to another app by using array, recordset, or concatenate the
data into a string. I want to concatenate into a string and pass it to SQL. But I have some limitation
on that. First, if I use varchar type, I only have a max of 8000 bytes. Second, if I use text type,
I cannot manuplicate this text variable. In other words, I cannot decode the string into the original
format.

Please help!

 

[WildWill]

If you want to extract data from one VB app to another, I suggest that you create an COM interface (and type library) that can be connected to from an external application such as getGridData. This is extensivly done in applications such as Excel Access etc and is quite easily implimented. Billy H

bhogar@acxiom.co.uk

 

[chrisli888]

Oh! Actually I am using ADO 2.5 to connect the VB app to the database. So, this connection problem is not an issue. The issue is how can I move multiple records from VB to SQL with just one trip to the database.