批量添加数据

频繁向数据库插入，就影响数据库的性能，批量录入就解决了。
  string ConStr = “server=.;database=test;user id=sa;pwd=;”;
        SqlConnection con = new SqlConnection(ConStr);
        con.Open();
        DataTable ds = new DataTable();
        DataColumn dc = new DataColumn();
        ds.Columns.Add(“fname”);
        ds.Columns.Add(“tag”);
        DataRow dr = null;
        for (int t = 0; t < 20; t++)
        {
            dr = ds.NewRow();
            dr[“fname”] = “dddddd”;
            dr[“tag”] = “ghjj”;
            ds.Rows.Add(dr);
        }
        SqlCommand cmd = new SqlCommand(“select top 1 fname,tag from a”, con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        SqlCommandBuilder builder = new SqlCommandBuilder(da);
        da.Update(ds);
        con.Close();
        da.Dispose();
        ds.Dispose();

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/wk122348545/archive/2008/09/23/2970194.aspx