用DataSet实现批量插入数据

SqlDataAdapter ad = new SqlDataAdapter("select top 1 * from users", ConfigurationManager.AppSettings["DataSource"].ToString());
DataTable dt = new DataTable();
SqlCommandBuilder cmb = new SqlCommandBuilder(ad);//这一句很关键，必不可少。
ad.Fill(dt);
int i;
for (i = 1; i < 10; i++)
{
DataRow dr = dt.NewRow();
dr["uid"] = "nid" + i.ToString();
dt.Rows.Add(dr);
}
ad.Update(dt);