Hi... I wanna add datum from CSV into SQL server DB table.

hi,

try

StreamReader sr = new StreamReader("C:\\samplecsv.txt");
string[] lines = sr.ReadToEnd().Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
string line = lines[0];
string[] value = line.Split(',');
DataTable dt1 = new DataTable();
DataRow row;
foreach (string dc in value)
{
    dt1.Columns.Add(new DataColumn(dc));
}
foreach(var newLine in lines)
{
    value = newLine.Split(',');
    if (value.Length == dt1.Columns.Count)
    {
        row = dt1.NewRow();
        row.ItemArray = value;
        dt1.Rows.Add(row);
    }
}

hope this will help you.