sqlconnection,sqlDataAdapter,sqlDataSet 都是控件生成的,下面新增和保存按钮的代码private void button8_Click(object sender, System.EventArgs e)
{
this.sqlConnection1 .Open ();
SqlCommandBuilder comcb=new SqlCommandBuilder (this.sqlDataAdapter1 );
this.sqlDataAdapter1 .UpdateCommand =comcb.GetUpdateCommand ();
this.sqlDataAdapter1 .Update (this.dataSet11 ,"verify");
this.sqlConnection1 .Close ();
}private void button9_Click(object sender, System.EventArgs e)
{ DataRow nr=this.dataSet11 .Tables ["verify"].NewRow ();
nr["v_date"]="2004-01-01";
this.dataSet11 .Tables ["verify"].Rows .Add (nr);
this.BindingContext [this.dataSet11 ,"verify"].Position =this.dataSet11 .Tables ["verify"].Rows.Count ;
}
{
this.sqlConnection1 .Open ();
SqlCommandBuilder comcb=new SqlCommandBuilder (this.sqlDataAdapter1 );
this.sqlDataAdapter1 .UpdateCommand =comcb.GetUpdateCommand ();
this.sqlDataAdapter1 .Update (this.dataSet11 ,"verify");
this.sqlConnection1 .Close ();
}private void button9_Click(object sender, System.EventArgs e)
{ DataRow nr=this.dataSet11 .Tables ["verify"].NewRow ();
nr["v_date"]="2004-01-01";
this.dataSet11 .Tables ["verify"].Rows .Add (nr);
this.BindingContext [this.dataSet11 ,"verify"].Position =this.dataSet11 .Tables ["verify"].Rows.Count ;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货