Send Dataset to SQL Server

[Mark Lauser]

Hello,

I have a vb.net application that accumulates records in a
one-table dataset (viewed on-screen with a datagrid).
Once the user is done creating records, I need to send
the table along with some other values to SQL server for
processing.

What would be the best way to populate a cursor in a
stored procedure with the records from the dataset? I am
hoping to avoid doing a trip to the server for each
record.

Thank you,
Mark Lauser

 

[Ken Tucker [MVP]]

Hi,

Maybe you could use OPENXML.
http://msdn.microsoft.com/msdnmag/issues/03/10/XMLFiles/

Ken

 

[Cor]

Hi Mark,

I have seen that more in this newsgroup, what is wrong with doing a trip to
the SQL server, does that not keep your data up to date for all users.

( I am also thinking on locking problems that has to be catched)?

While the user has the shortest wait time for updating, because it are very
small parts doing that.

The dataset haschanges methode is not for nothing I think.

Just my thoughts, but maybe you can tell me what I see wrong?

Cor

 

[Mark Lauser]

-----Original Message-----
Hi Mark,

I have seen that more in this newsgroup, what is wrong with doing a trip to
the SQL server, does that not keep your data up to date

for all users.


Thank you for your thoughts. You are right, and in most
cases I do things the way you have suggested.

However, this particular process uses the set of records
all at once to perform one transaction. After the
transaction takes place, the records are not needed any
longer (in their present form). Other users wouldn't
benefit from seeing these records before the transaction
is completed.

When the user is collecting records, the process is very
fast. They may be able to collect records faster than
the application can perform a database update (over the
Internet). So I am hoping to refrain from communicating
with the server until they are ready to perform the whole
transaction (so as not to slow them down).

So, whether I send all of the records at once, or I do a
trip to the server for each record, it is going to happen
all at once when the user is done.

Thanks again,
Mark Lauser - Crimson Software

 

[Mark Lauser]

-----Original Message-----
Hi,

Maybe you could use OPENXML.
http://msdn.microsoft.com/msdnmag/issues/03/10/XMLFiles/

Ken

Thanks Ken, I figured there was something out there like
this.

Mark

 

[Peter Huang]

Hi Mark,

I have reviewed the issue, if I have any new information about the issue, I
will update with you ASAP.

Have a nice day!

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Yan-Hong Huang[MSFT]]

Hi Mark,

I agreed with Ken on it. Mark, could you please let us know if it meets
your need? If you have any more concerns on it, please feel free to post
here.

Thanks very much for participating the community.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.