با دستور زیر فرمم پر میشه و با دیتاست پر نمیشه
private void insertToDB(TextBox txtCheckNumber, FarsiLibrary.Win.Controls.FADatePicker date, TextBox txtBank, TextBox txtBranch, TextBox txtAmount, TextBox txtPoshtNumber)
{
OleDbConnection cn = new OleDbConnection(s);
string cmdString = "insert into Factor(CustomerID, CustomerName, AmountNaghd, CheckNumber,CheckDate,Bank, Branch,mablaghCheck,PoshtNumber,JameCheck,Descript ion,ReciveAmountNumber, ReciveAmountHarf, ReciverName, PayerName,NumberFactor)";
if(txtCheckNumber.Text.Trim().Length>0)
cmdString+="values('" + txtCustomerId.Text.Trim() + "','" + txtCustomerName.Text.Trim() + "','" + txtMablaghNaghd.Text.Trim() + "','" +
txtCheckNumber.Text.Trim() + "','" + date.Text.Trim() + "','" + txtBank.Text.Trim() + "','" + txtBranch.Text.Trim() + "','" + txtAmount.Text.Trim() + "','" + txtPoshtNumber.Text.Trim() + "','" +
txtJameCheck.Text.Trim() + "','" + txtDescription.Text.Trim() + "','" + txtMablaghNumber.Text.Trim() + "','" + txtMablaghHarf.Text.Trim() + "','" + txtReviverName.Text.Trim() + "','" + txtPayerName.Text.Trim() + "','" + numtxt.Text.Trim() + "')";
else
cmdString += "values('" + txtCustomerId.Text.Trim() + "','" + txtCustomerName.Text.Trim() + "','" + txtMablaghNaghd.Text.Trim() + "','" +
"','','','','','','" +
txtJameCheck.Text.Trim() + "','" + txtDescription.Text.Trim() + "','" + txtMablaghNumber.Text.Trim() + "','" + txtMablaghHarf.Text.Trim() + "','" + txtReviverName.Text.Trim() + "','" + txtPayerName.Text.Trim() + "','" + numtxt.Text.Trim() + "')";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = cn;
cmd.CommandText = cmdString;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cn = null;
cmd = null;
}
اینم کد دکمه ذخیره:
insertToDB(txtCheckNumber1, date1, txtBank1, txtBranch1, txtAmount1, txtPoshtNumber1);
insertToDB(txtCheckNumber2, date2, txtBank2, txtBranch2, txtAmount2, txtPoshtNumber2);
insertToDB(txtCheckNumber3, date3, txtBank3, txtBranch3, txtAmount3, txtPoshtNumber3);
insertToDB(txtCheckNumber4, date4, txtBank4, txtBranch4, txtAmount4, txtPoshtNumber4);
insertToDB(txtCheckNumber5, date5, txtBank5, txtBranch5, txtAmount5, txtPoshtNumber5);
insertToDB(txtCheckNumber6, date6, txtBank6, txtBranch6, txtAmount6, txtPoshtNumber6);
insertToDB(txtCheckNumber7, date7, txtBank7, txtBranch7, txtAmount7, txtPoshtNumber7);
// MessageBox.Show("اطلاعات با موفقیت ثبت شد");
ReportForm myForm = new ReportForm();
myForm.ShowDialog();
ClearTextBox();
UpdateID();
Fill_num();