public SqlDataAdapter da;
public DataSet ds =new DataSet();private void Form2_Load(object sender, System.EventArgs e)
{
da=new SqlDataAdapter("select * from STUDENT",sqlConnection1);
da.Fill(ds,"student");
grid.SetDataBinding(ds,"STUDENT");
}
private void button1_Click(object sender, System.EventArgs e)
{
da.Update(ds,"STUDENT");
}
public DataSet ds =new DataSet();private void Form2_Load(object sender, System.EventArgs e)
{
da=new SqlDataAdapter("select * from STUDENT",sqlConnection1);
da.Fill(ds,"student");
grid.SetDataBinding(ds,"STUDENT");
}
private void button1_Click(object sender, System.EventArgs e)
{
da.Update(ds,"STUDENT");
}
private void button1_Click(object sender, System.EventArgs e)
{
da.Update(ds,"STUDENT");
}
这段修改的代码有问题
直接修改数据库还要再执行一些update命令
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM t_msg",myConn);
DataSet ds = new DataSet();
myCommand.Fill(ds,"t_msg");
DataRow newRow = ds.Tables["t_msg"].NewRow();
newRow["t_title"]= "Jay";
ds.Tables["t_msg"].Rows.Add(newRow);OleDbCommandBuilder cb=new OleDbCommandBuilder(myCommand;)// 这句不能少
myCommand.Update(ds,"t_msg");
无聊就接分来了
webform上这样是肯定不行的,因为是先执行formload事件,然后执行按纽事件,所以数据就还是原来没有修改之前的。
winform上不知道是不是一样。