Load the second combobox

Israel

Hi!

I have a combobox with three items:
Toyota
Kia
Hyndai

Then I have a small table with two columns (Marks and Models):

Marks | Modelos
Toyota: Camry
Toyota: Celica
Toyota: Corolla
Kia: Optima
Kia: Picanto
Kia: Sportage
Hyundai: Accent
Hyundai: Azera
Hyundai: Elantra

When I select one mark. What happening? I found in the combobox model the table's name repeted in that combobox:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\rentacar\rentacar\\app_data\rentacar.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from carsconfig where cars ='" + cbxMarkConfig.Text + "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

cbxModelsConfig.Items.Add("models"); // it will show the code

}

else

{

MessageBox.Show("A record with a code of " + cbxMarkConfig.Text + " was not found");

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger11y ago
no this is your code..i just only make the function and call in load event. what type of error you facing.
Israel11y ago
@Joginder Thanx for the codes. But its doesnt work properly.
Joginder Banger11y ago
this type of problem occur when page is post back.

protected void Page_Load(object sender, EventArgs e){
if (!IsPostBack)
        {
            binddropdown();

        }
    }

public void binddropdown()
{

tring connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\rentacar\rentacar\\app_data\rentacar.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from carsconfig where cars ='" + cbxMarkConfig.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
cbxModelsConfig.Items.Add("models"); // it will show the code

}
}
else
{
MessageBox.Show("A record with a code of " + cbxMarkConfig.Text + " was not found");
}

}

}

and second question:
create a event of combobox selectedINDEX.
On this event bind another combobox same as it is.