خطا در کوئری گرفتن

[programerinfonet]

سلام
من کد زیر رو توی رویداد change تکست باکس نوشتم


LBL_Customer.ResetText();

{
SqlCommand cmd_customer = new SqlCommand("select name,family from Customer_TB where id='" +TXT_customerID.Text +"'", SQL_Connection);
SqlDataReader sdr_customer = cmd_customer.ExecuteReader();
while (sdr_customer.Read())
{
LBL_Customer.Text = sdr_customer["name"].ToString() + " " + sdr_customer["family"].ToString();

}
sdr_customer.Close();
}
//************************************************** ************************************************** **********************************************
{
CMB_CompanyList.Items.Clear();
SqlDataAdapter AD_Company = new SqlDataAdapter("SELECT CompanyMainMas_TB.ID, Customer_TB.Name+' '+ Customer_TB.Family AS CustomerInfo,CompanyMainMas_TB.id, CompanyMainMas_TB.CompanyName, CompanyMainMas_TB.RegisterNO, CompanyMainMas_TB.NationalID FROM Customer_TB INNER JOIN CompanyMainMas_TB ON Customer_TB.ID = CompanyMainMas_TB.CustomerID where dbo.Customer_TB.ID='" + TXT_customerID.Text + "'", SQL_Connection);
AD_Company.Fill(dt);
CMB_CompanyList.DataSource = dt;
CMB_CompanyList.DisplayMember = "CompanyName";
CMB_CompanyList.ValueMember = "id";

اما موقع اجرا خطای زیر رو میده :
Item Collection Can Not Be Modified When The DataSource Property Is Set .

[arash69]

سلام؛
فکر کنم اگر ترتیب این سه سطر رو به این صورت تغییر بدین، مشکل حل میشه:

CMB_CompanyList.DisplayMember = "CompanyName";
CMB_CompanyList.ValueMember = "id";
CMB_CompanyList.DataSource = dt;

[programerinfonet]

نه نمیشه
مشکل فکر نکنم اون قسمت باشه .

[behzadkhan]

با سلام

ببین ایرادت برطرف می شه:

==============================


CMB_CompanyList.DataSource = null;


CMB_CompanyList.DataSource = dt;


CMB_CompanyList.DisplayMember = "CompanyName";


CMB_CompanyList.ValueMember = "id";





با تشکر