如何将整个DataTable插入数据库。 我用代码创建一个与数据库结构相同的DataTable。然后向DataTable中插入几行数据,有没有方法将这个DataTable一次性插入数据库啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可以用CommandBuilder如下:public DataSet SelectSqlSrvRows(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName) { SqlConnection myConn = new SqlConnection(myConnection); SqlDataAdapter myDataAdapter = new SqlDataAdapter(); myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn); SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet(); myDataAdapter.Fill(custDS, "Customers "); //在这里修改数据集中的数据 myDataAdapter.Update(custDS, "Customers "); myConn.Close(); return custDS; } SqlConnection myConn = new SqlConnection(myConnection); SqlDataAdapter myDataAdapter = new SqlDataAdapter(); myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn); SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter); myConnection : 数据库连接字符串mySelectQuery : sql 语句 sqlDataAdapter的update方法,自己可以查查资料。 郁闷,今天RP值太低了,现在能运行成功了。不知道刚才哪错了。 把代码贴出来DataTable dt = new DataTable(); string a = ConfigurationManager.ConnectionStrings["sqlConn"].ToString(); SqlConnection con = new SqlConnection(a); SqlCommand cmd = new SqlCommand("select * from student where 1=2", con); SqlDataAdapter sda = new SqlDataAdapter(cmd); SqlCommandBuilder Builder = new SqlCommandBuilder(sda); sda.Fill(dt); DataRow dr; dr = dt.NewRow(); dr[0] = "1"; dr[1] = "q"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "2"; dr[1] = "W"; dt.Rows.Add(dr); sda.Update(dt); 用C#实现在线数据的加密传输 用户在网页上输入文本并可设置样式颜色等,最后将文本变为图片 数据表中增加一列查询结果 html关于用post方法传数据的问题 try{}catch{}问题+objrea.read()问题?????十万火急在线等。 请高手帮忙看看button 谁有AspNet Menu控件的安装系列号? 版主请看,为什么精华区里的文章连接错误啊? 求助,Oracle数据库中数据参数传递问题 多条件查询问题,本人SQL很烂!求大神帮助! XP系统的开发环境配置 提示框总是弹出空白页的问题。。
如下:public DataSet SelectSqlSrvRows(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName) {
SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS, "Customers "); //在这里修改数据集中的数据
myDataAdapter.Update(custDS, "Customers "); myConn.Close(); return custDS;
}
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);
myConnection : 数据库连接字符串
mySelectQuery : sql 语句
DataTable dt = new DataTable();
string a = ConfigurationManager.ConnectionStrings["sqlConn"].ToString();
SqlConnection con = new SqlConnection(a);
SqlCommand cmd = new SqlCommand("select * from student where 1=2", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
sda.Fill(dt);
DataRow dr;
dr = dt.NewRow();
dr[0] = "1";
dr[1] = "q";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "2";
dr[1] = "W";
dt.Rows.Add(dr);
sda.Update(dt);