Import data from Xml to Sql in vs2003

[Tash18]

Hi guys.. Actually i have an web application running on vs2003 it fetches the records from a list of xml file now i want to import all my data that is present in the xml file to sql db(sybase).. can any one guide me as to how can i import the data using c# coding... i googled alot dint get the apt one..I tried using Sqlbulkcopy but that doesnt work with vs2003... and also there are duplicate rows in my xml files... Thanks in advance...

[Mycroft Holmes]

Read in your xml file convert it into a datatable clean out the duplicates save each record to the database via a database connection and a sqlcommand

Never underestimate the power of human stupidity RAH

[Tash18]

Thanx for ur response... since im a fresher do u hav any sample codes or can u mention any tutorials that wil provide me a helping hand... anyways thanks for ur reply... regards, Thashif

[Mycroft Holmes]

Sorry, that's maybe 4 hours work and if I did that for you then how do you expect to become anything but a "fresher" As a general comment, learn to use the keyboard, typos I can live with, but that crap you used is just horrible.

Never underestimate the power of human stupidity RAH

[Tash18]

I neva asked u 2 work or complete the task for me.. i only asked u 2 mention any tutorials or sample codes if u know.. wel learn 2 use keyboard ???? what does that mean??? again, crap??? i dint get u....

[Mycroft Holmes]

<> wrote:

I neva asked u 2 work or complete the task for me

You are right so take the ideas I gave you one line at a time and feed them into Google, look at the results and you will find lots of articles and tutorial on each of the subjects. Then put them together in a solution. As for your keyboard use, are you serious, there are 101 keys on most keyboards and you want to use your like a bloody phone. Wake up to yourself and communicate like a professional or at least competent person.

Never underestimate the power of human stupidity RAH