create table MyTable (
n int identity( 1 , 1 ) primary key,
name varchar( 10 ))

static void doSome()
{
    DataTable dt = new DataTable();
    dt.Columns.Add(new DataColumn("name", typeof (string)));
    for (int i = 0; i < 10;i++ )
    {
        DataRow dr = dt.NewRow();
        dr[0] = Convert.ToChar(65 + i).ToString();
        dt.Rows.Add(dr);
    }
    using (SqlConnection cnn = new SqlConnection(Settings.Default.MyConnectString))
    {
        cnn.Open();
        using(SqlBulkCopy bulk = new SqlBulkCopy(cnn,SqlBulkCopyOptions.Default,null))
        {
            bulk.DestinationTableName = "MyTable";
            bulk.WriteToServer(dt);
        }
    }
    Console.WriteLine("writed");
    Console.ReadKey();
}