Dataset, SqlAdapter & Inserts

[Ben Dill]

I working in C# with the 1.1 version of the .Net framework. I have a text
file that is tab delimited that I am trying to insert into my sql server (MS
Sql server 2000).

I am able to use the ODBC text driver to load the file into a dataset via a
OdbcDataAdapter.

My problem is, how do I get the data from the dataset into Sql server? It
seems like all the examples I've seen with the dataadapters doing inserts or
updates have to do with a dataset the generated by the dataadapter. My
problem is that my dataset is generated by a text file, but is inserting
into Sql server.

Can anyone please show me the correct approach to my problem?

Thanks,
Ben

 

[William Ryan eMVP]

Just configure a different adapter pointing to the Sql Server. Two data
adapters, one to fill, one to post back to the Sql Server - passing in the
same dataset. This should help...
http://www.knowdotnet.com/articles/efficient_pt4.html


--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Kevin Yu [MSFT]]

Thanks for William's quick response!

Hi Ben,

If you need to pull data from a text file, besides using a DataSet as a
temporary place for storing data, we can also use DTS in SQL server. Please
check the following link for more information.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/dts_overview.asp

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