C#

// Setup connection and command.
SqlConnection conn = new SqlConnection("...");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO MyTable (Field1, Field2, Field3) " +
  "VALUES(@Field1, @Field2, @Field3)";
SqlParameter param1 = cmd.Parameters.Add("@Field1", SqlDbType.BitInt);
SqlParameter param2 = cmd.Parameters.Add("@Field2", SqlDbType.NVarChar, 40);
SqlParameter param3 = cmd.Parameters.Add("@Field3", SqlDbType.NVarChar, 40);
using (conn) // Closes the connection when done (even in error)
{
  conn.Open();
  while (true)
  {
    // Open CSV file, for example, then...
    string line = read next line from data file;
    // If no more lines, return false; otherwise, continue...
 
    string[] fields = line.Split(','); // Assumes CSV
    int id = Convert.ToInt32(fields[0]);
 
    param1.Value = id;
    param2.Value = fields[1];
    param2.Value = fields[2];
    cmd.ExecuteNonQuery();
  }
}