Click here to Skip to main content
14,641,305 members
Rate this:
Please Sign up or sign in to vote.
See more:
Help me to solve this problm
i have to read string text file and split it by comma and finaly save it into database.....
ex:--In text file : suhas,kumar,55555,male,22.
i have to store this data into database...
then again read next line....

private void split()

    StreamReader rd1 = new StreamReader("c:\\temp1.txt");//string is suhas,kumar,8888888888,male.
    string str12 = rd1.ReadLine();
    string[] str1 = str12.Split(',');
    // splitmsg(str1);
    foreach (string part in str1)
       //display array string


how can i use values in insert query..
Updated 11-Jul-11 3:45am
#realJSOP 11-Jul-11 9:57am
Rate this:
Please Sign up or sign in to vote.

Solution 2

But i need that in different columns...
like---> Fname Lname Phno Gender
suhas kumar 55555 male
ravi kumar 5555 male
Rate this:
Please Sign up or sign in to vote.

Solution 1

Easy! Assuming you want to put each string that you have split on a separate row, then you just need a loop:
foreach (string s in str1)
   using (SqlCommand cmd = new SqlCommand("INSERT INTO myTable (myColumnName) VALUES (@STR)", con))
      cmd.Parameters.AddWithValue("@STR", s);
You could do this with the SqlCommand outside the loop, and it would be a lot more efficient, but that is an exercise for the reader - this just shows the general principle.

BTW: you don't need to call ToString on objects you already know are strings: it doesn't do anything useful and just looks like you don't care...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100