public void Page_Load(Object src,EventArgs e) { //连接语句 string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;"; string strSel = "select * from Score";
DataSet ds = new DataSet(); OleDbConnection MyConn = new OleDbConnection(MyConnString); OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
我现在要实现的就是在datagrid中新添加、修改一行或多行再保存到数据库,请问可以如上这样做吗,请给出源程序,或者有更好的方法也可以,在线等哦 ,
dr.BeginEdit();
dr["columns"]=this.textbox.text;
this.dataset1.table.AddtableRow (dr);
dr.EndEdit();
要不我们MSN交流吧,MSN:[email protected]
SqlCommandBuilder m_CB = new SqlCommandBuilder( m_DA );
SqlCommandBuilder 对象会判断RowState的状态的
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
string strSel = "select * from Score";
DataSet ds = new DataSet(); OleDbConnection MyConn = new OleDbConnection(MyConnString);
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"Score");
MyConn.Open();
DataRow dr = ds.Tables["Score"].NewRow();
ds.Tables["Score"].NewRow();
MyAdapter.Update(ds,"Score");
dr["Name"] = tb.Text;
dr["Class"] = "201";
dr["Chinese"] = 0;
dr["Math"] = 100;
dr["English"] = 90;
dr["Physics"] = 90;
dr["History"] = 60;
MyAdapter.Update(ds,"Score");
ds.Tables["Score"].Row[2].Delete();
MyAdapter.Update(ds,"Score");
score.DataSource = ds;
score.DataMember = "Score";
score.DataBind();
MyConn.Close();
}