مبتدی: انتقال فايل csv به sql

 private void button1_Click(object sender, EventArgs e)
{
string ssqltable = "Log";
SqlCoection con = new SqlCoection(@"Data Source=POURALI-PA-4114;Initial Catalog=Test;Integrated Security=True");
string filepath = "D:\alert.csv";
StreamReader sr = new StreamReader(filepath);
string line = sr.ReadLine();
string[] value = line.Split(',');
foreach (string dc in value)
{
dt.Columns.Add(new DataColumn(dc));
}
while (!sr.EndOfStream)
{
value = sr.ReadLine().Split(',');
if (value.Length == dt.Columns.Count)
{
row = dt.NewRow();
row.ItemArray = value;
dt.Rows.Add(row);
}
}
SqlBulkCopy bc = new SqlBulkCopy(con.CoectionString, SqlBulkCopyOptions.TableLock);
bc.DestinationTableName = "Log";
bc.BatchSize = dt.Rows.Count;
con.Open();
bc.WriteToServer(dt);
bc.Close();
con.Close();
MessageBox.Show("Done!!!");
}