Insert comma deliminated data into sql server

Ritu

I have xml file with below data. There is no xml tags and headers but file saved like (abc.xml)

1,"00277S-1","PO-003988"
2,"00119E","PO-003988"
3,"00277E-1","PO-003988"
4,"00700L","PO-003988"
5,"06900E","PO-003988"
6,"06901K","PO-003988"
7,"06901T","PO-003988"
8,"06901R","PO-003988"
9,"06901Y","PO-003988"
10,"01119C","PO-003988"

I want to read this file and get this data into sql table using c#. How this can be done.

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Srinivasan Ramamoorthi5y ago
Accepted answer
Refer this article https://stackoverflow.com/questions/29549229/reading-a-delimited-text-file-by-line-and-by-delimiter-in-c-sharp/29549289
+2
Nitin Sontakke4y ago
From strictly technical point of view, file extensions are virtually useless.

Their practical use is only to associate files with applications to open with by default, that is to say, when you double click on the file. Except this there is no real meaning to what extension you give to a file. It is the contents that matters most.

Because files with extension .csv open by default in MS-Excel, many people, including IT professionals, believe that it is an Excel file.

In fact, in most cases, it is a good idea to just change the file extension just to fool the users. For example, if you don't already know, the .xlsx files are actually .zip files. You can rename one and open and see it yourself.

Bottom line, do not give too much importance to the file extension.

Hope it clarifies!
+1
Ritu5y ago
Thanks.
+1