var sql = @"Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20131029153010;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20131029153010.mdf";

            SqlBulkCopy bc = new System.Data.SqlClient.SqlBulkCopy(sql);
            bc.DestinationTableName = "TestInfo";
            DataTable t = new DataTable();
            t.Columns.Add("id");
            t.Columns.Add("MyProperty");
            DataRow r = t.NewRow();
            r[0] = 1;
            r[1] = "2";
            t.Rows.Add(r);

            bc.WriteToServer(t);
            bc.Close();

优质内容筛选与推荐>>
1、Servlet3.1规范翻译——与其它规范有关的要求
2、腾讯招聘爬虫
3、dll 问题 (转)
4、HttpMessageConvert
5、20169201 实验三 敏捷开发与XP实践报告