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 str12 = rd1.ReadLine();
string[] str1 = str12.Split(',');
foreach (string part in str1)
{
MessageBox.Show(part.ToString());
}
}
how can i use values in insert query..