Creating an SQL2000 database using an in memory Dataset

  • Thread starter Thread starter Paul Cleghorn
  • Start date Start date
P

Paul Cleghorn

Hi
I would like to create an in memory Dataset(in VB.net)
and use it's schema to create a database within Sql2000.
Later I would like to update rows the in-memory DS and
then update the newly created SQL2000 database with
changed values.
How the hell do you do this?

MTIA
 
Hi Paul,

ADO.NET does not provide an uniform way to manipulated database schema.
You will either have to invoke Sql stataments or use good old ADOX.
 
Paul,

You may want to have a look at the SQLXML Managed Classes. They may help you accomplish this, so have a look at this article to get you started:

SQLXML Managed Classes
http://msdn.microsoft.com/library/d...lasses.asp?frame=true: SQLXML Managed Classes

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top