>Talking of Datasets, if let say I have a PolicyHolder table with 50,000 records, how can I pull all the records and disconnect from my Database from C#/VB.NeT?
>
>Can you explain as there might be difference between a Datasets created with Delphi/Interbase and C#/VB/MS SQL.
>
>I just need an answer, please.
>
>Thanks.Should be no different. You connect to the DB using the proper driver oir provider. Doesn't matter if it's SQL Server or Interbase. Any of the examples and connextion strings you can get online would work. Once you run your query and obtain a DataSet (although 50,000 records is a little to many to bring all at once), then you close the connection and you have a local DataSet to work with. Not as powerful as with VFP, but C#/VB.NET can do a lot with it.