help me:-read string frm text file & store into BD

Question

1.00/5 (1 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
        MessageBox.Show(part.ToString());

    }
}

how can i use values in insert query..

Posted 11-Jul-11 3:25am

suhaskumar86.sg

Updated 11-Jul-11 3:45am

Manas Bhardwaj

v2

Add a Solution

Comments

#realJSOP 11-Jul-11 9:57am

DO NOT REPOST YOUR QUESTION!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-07-11T03:51:00

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);
      cmd.ExecuteNonQuery();
      }
   }

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...

suhaskumar86.sg · Answer 2 · 2011-07-11T20:39:00

Solution 2

But i need that in different columns...
like---> Fname Lname Phno Gender
suhas kumar 55555 male
ravi kumar 5555 male

Posted 11-Jul-11 20:39pm