programerinfonet
سه شنبه 26 فروردین 1393, 12:05 عصر
سلام
من کد زیر رو توی رویداد 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 .
من کد زیر رو توی رویداد 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 .