private OleDbDataAdapter daClient;
private OleDbDataAdapter daAdd;
private OleDbDataAdapter daDelete;
private string dataSource;
private DataSet dataSet;
private System.Windows.Forms.Button btnExit;
private System.ComponentModel.Container components = null;
private System.Windows.Forms.Label label1;
private string mainSql = "Select * From people ";
private string deleteSql = "delete * from people ";
private string addSql = "insert into people (f,m,n,id) values(1,1,1,100)";
private System.Windows.Forms.Button BtnDeleteAll;
private int rowsNumber;
private void btnUpdate_Click(object sender, System.EventArgs e){
if(dataSet.HasChanges()){
try{
if
(this.dataSet.Tables[0].Rows.Count==this.rowsNumber){ OleDbCommandBuilder
cmd = new
OleDbCommandBuilder(daClient); daClient.Update(dataSet,"people"); } else{ //the problem what to write here?
}
}
catch(System.Exception exc){
this.label1.Text = "can not update data "+exc.ToString();
}
}
}