hi;
I am having a combobox in my for, I am getting all the data members into it
using the database MYSQL. Everything is getting right. The data members are
getting added to it
private void comboBox1_DropDown(object sender, EventArgs e)
{
myCon = "DRIVER={MySql ODBC 5.1
Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=TEST;UID=root;PWD=vikas;OPTION=3";
OdbcCon = new System.Data.Odbc.OdbcConnection(myCon);
OdbcCon.Open();
if (OdbcCon.State == ConnectionState.Open)
{
try
{
string str = "select Sender_id from sender_id where User_id = 58";
OdbcCom = new System.Data.Odbc.OdbcCommand(str, OdbcCon);
OdbcDr = OdbcCom.ExecuteReader();
while (OdbcDr.Read())
{
string xyz = (string)OdbcDr[0];
comboBox1.Items.Add(xyz);
}
}
catch (System.Data.Odbc.OdbcException ex)
{
//This I have declared a read only textbox to see whatever response i am
getting after any line of code
LogText.AppendText("\r\n" + ex.Message);
}
}
else
{
LogText.AppendText("\r\n The connection could not be opened");
}
}
But this is getting me a problem, that is whenevr I click on the drop down
Icon, the combobox is flooded with a copy of
itself. Because I have added this to dropDown event of ComboBox. please
guide me what change should i make there.
I am using tagPage in my form.
