62,051
社区成员
发帖
与我相关
我的任务
分享
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);
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;
}