دستور رفرش بعد از حذف یک رکورد

[nafisehk]

سلاممم
من محتوای یه جدول و با دستورهای زیر به کنترل های فرم بایند کردم


privatevoid BindCompaniesArchiveToControls()
{
#region ClearControlsBindings

txtCompanyName.DataBindings.Clear();
txtArchiveNumber.DataBindings.Clear();
cmbStuffName.DataBindings.Clear();
txtRegisterDate.DataBindings.Clear();
txtSubject.DataBindings.Clear();
chkIsPursuit.DataBindings.Clear();
chkIsCohort.DataBindings.Clear();
chkIsCustomer.DataBindings.Clear();
txtPursuitDate.DataBindings.Clear();
txtGharardadDate.DataBindings.Clear();
txtFinishDate.DataBindings.Clear();
txtStuffCount.DataBindings.Clear();
txtPrice.DataBindings.Clear();
txtRemainAmount.DataBindings.Clear();
cmbActionArea.DataBindings.Clear();
txtManager.DataBindings.Clear();
txtCityPhoneCode.DataBindings.Clear();
txtPhone.DataBindings.Clear();
txtFax.DataBindings.Clear();
txtMasule.DataBindings.Clear();
txtMasulPhone.DataBindings.Clear();
txtEmail.DataBindings.Clear();
txtAddress.DataBindings.Clear();
txtPostalCode.DataBindings.Clear();
txtDescription.DataBindings.Clear();
#endregion
mySqlCommand.Parameters.Clear();
mySqlCommand.Connection = mySqlConnection;
mySqlCommand.CommandText = "select * from CompaniesArchive";
mySqlDataAdapter.SelectCommand = mySqlCommand;
mySqlDataAdapter.Fill(myDataSet, "CompaniesArchive");
txtCompanyName.DataBindings.Add("Text", myDataSet, "CompaniesArchive.CompanyName");
txtArchiveNumber.DataBindings.Add("Text", myDataSet, "CompaniesArchive.ArchiveNumber");
cmbStuffName.DataBindings.Add("SelectedItem", myDataSet, "CompaniesArchive.StuffName") ;
txtRegisterDate.DataBindings.Add("Text", myDataSet, "CompaniesArchive.RegisterDate");
txtSubject.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Subject");
chkIsPursuit.DataBindings.Add("Checked", myDataSet, "CompaniesArchive.IsPursuit");
chkIsCohort.DataBindings.Add("Checked", myDataSet, "CompaniesArchive.IsCohort");
chkIsCustomer.DataBindings.Add("Checked", myDataSet, "CompaniesArchive.IsCustomer");
txtPursuitDate.DataBindings.Add("Text", myDataSet, "CompaniesArchive.PursuitDate");
txtGharardadDate.DataBindings.Add("Text", myDataSet, "CompaniesArchive.GharardadDate");
txtFinishDate.DataBindings.Add("Text", myDataSet, "CompaniesArchive.FinishDate");
txtStuffCount.DataBindings.Add("Text", myDataSet, "CompaniesArchive.StuffCount");
txtPrice.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Price");
txtRemainAmount.DataBindings.Add("Text", myDataSet, "CompaniesArchive.RemainAmount");
cmbActionArea.DataBindings.Add("SelectedItem", myDataSet, "CompaniesArchive.ActionArea");
txtManager.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Manager");
txtCityPhoneCode.DataBindings.Add("Text", myDataSet, "CompaniesArchive.CityPhoneCode");
txtPhone.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Phone");
txtFax.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Fax");
txtMasule.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Masul");
txtMasulPhone.DataBindings.Add("Text", myDataSet, "CompaniesArchive.MasulPhone");
txtEmail.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Email");
txtAddress.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Address");
txtPostalCode.DataBindings.Add("Text", myDataSet, "CompaniesArchive.postalCode");
txtDescription.DataBindings.Add("Text", myDataSet, "CompaniesArchive.Description");
mySqlConnection.Open();

mySqlConnection.Close();
}



حالا بعد حذف یک رکورد میخوام دیگه تو کنترل ها نمایش داده نشه اماااااا باز نشونش میده


کد که برا حذف نوشتم اینه:



DialogResult Answer = MessageBox.Show(" \n" + txtArchiveNumber.Text.Trim() + "\n ", " ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (Answer == DialogResult.Yes)
{
mySqlCommand.Parameters.Clear();
mySqlCommand.Connection = mySqlConnection;
mySqlCommand.CommandText = "Delete from CompaniesArchive where ArchiveNumber=@ArchiveNumber";
mySqlCommand.Parameters.AddWithValue("@ArchiveNumber",txtArchiveNumber.Text.Trim());
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();

BindCompaniesArchiveToControls();
}


مشکلی این کدا چیه؟؟؟؟

[nafisehk]

مشکلم حل شد

باید قبل از از select...مقدار dataset رو پاک کنم...

mydataset.clear();