txt file import c# to sql?

void TextDateYukle()
{
  using (StreamReader sr = new StreamReader(File.Open("C:\\Tr500.txt", FileMode.Open)))
  {
    using (SqlConnection txtbaglan = new SqlConnection("server=.;database=.......;trusted_connection=true"))
    {
      txtbaglan.Open();
      string line = "";
      while ((line = sr.ReadLine()) != "")
      {
        string[] parts = line.Split(new string[] { "," }, StringSplitOptions.None);
        string cmdTxt = string.Format("INSERT INTO pdks(cihazno,cardno,shift,tarih,saat) VALUES ('{0}','{1}','{2}','{3}','{4}')", parts[0], parts[1], parts[2], parts[3], parts[4]);//", parts[0], parts[1]);
        using (SqlCommand cmddd = new SqlCommand(cmdTxt, txtbaglan))
        {
          cmddd.ExecuteNonQuery();
        }
      }
    }
  }
}