DataSet to SQL Server Table ...

[Guest]

Hi all

Can somebody tell me a easy way for the following:
- I have a DataSet in C# (with one table)
- I have SQL Server (2000 or 2005)
Now I would like to store the data in the DataSet into a SQL Server
Table. I need to do this in C# and not in IS.
Also this question: Is there a possibility to map the fields?
For example: DataSet Field X1 goes to SQL Table Field X2 ...

Would be very happy for any comments,
thanks in advance.

Best regards
Frank Uray

 

[VJ]

Check out the SQL Data Adapter class... here is a sample link..

http://support.microsoft.com/default.aspx?scid=kb;en-us;q308507

HTH
VJ