two combox with three textbox two tables populate bases on c

Ifraz Imanudeen

I have two tables, 1st FileFolderPath and 2nd Product_Type

FileFolderPath
`Id`     `Product`

Product_Type
`Id`     `Product_Id`     `Product_Type`     `Folder_Path`

`Product_Id` in Table Product_Type is the `Id` of FileFolderPath

In form i have below controls

[PID.Text]        [comboBox2]
[PTID.Text]      [comboBox3]
[PPath.Text]

---------------------------------------------------------------

"PID.Text", "comboBox2" is related to table "FileFolderPath"

"PTID.Text", "PPath.Text", "comboBox3" is related to table "Product_Type"

On form Load i made [comboBox2] populate data "Product" from Table FileFolderPath

    SELECT * FROM FileFolderPath

1st Issue: when i select a `Product` from [comboBox2], i need `Id` to be filled in [PID.Text].

02nd Issue: I populated [comboBox3] on selection on [comboBox2], but i need `Id` to been filled in [PTTID.Text] and `Folder_Path` to be filled in [PPath.Text] when i select `Product_Type` from [comboBox3].

I tried several search i couldn't find a solution. So i feel this cannot be a duplication.

Kindly someone help.

5 Replies

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

Hiten Pandya8y ago
Accepted answer
Hi Ifraz Imanudeen,

Please try the below code for filling combobox I think there might be problem in combobox filling.
SqlCommand cmd = new SqlCommand("select * from tb_City", conn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
cmb1.DataSource = ds.Tables[0];
cmb1.DisplayMember = "City";
cmb1.ValueMember = "CityID";
It perfectly fills the combobx and when I changed the item from combobox the code from change event works perfectly.

Hope it helps you.

Thanks.
+2
Hiten Pandya8y ago
Hi Ifraz Imanudeen,

Thank you for accepting the answer. Glad that code works for you and you got your solutions.

Happy Coding :D

Thanks.
+2
Ifraz Imanudeen8y ago
Thank you very much Hiten Pandya.
Solved all my issues.
+1
Ifraz Imanudeen8y ago
Hiten Pandya

Thanks for the response.

comboBox2.SelectedValue.ToString(); doesn't seems to work.I did a void

Load_Product()
{
string da = new SqlDataAdapter("SELECT * FROM FileFolderPath",conn);
DataTable dt = new DataTable();
da.fill(dt);
for(int i = 0; i < dt.rows.count; i++)
{
string pi = dt.rows[i]["Id"].ToString() as string;
string p = dt.rows[i]["Product"]. ToString ();
comboBox2.Items.Add(p);
comboBox2.DisplayMember = p;
comboBox2.ValueMember = pi;
comboBox2.DataSource = dt;PID.Text = pi;
}
}
And in form load i mentioned Load_Product
And in comboBox2_SelectedIndexChange i mentioned PID.Text = comboBox2.SelectedValue.ToString() as string;
Still the "Id" of the "Product" from Table "FileFolderPath" is not shown in PID.Text when i select items in the Combobox
+1
Hiten Pandya8y ago
Hi Ifraz Imanudeen,

If I understand your question correctly then,

Solution of Issue 1:

You can use the SelectedIndexChanged event of a combobox and get the
selectedvalue from combobox and just simply bind it to your textbox.
txt1.Text = cmb1.SelectedValue.ToString();
Solution of Issue 2:

You want the Id to be filled in [PTTID.Text] which you can do with selected value of combobox and for the FolderPath you can get the data in datatable and simply use select method to find the particular folderpath by passing your combobox selected value as a parameter.

see the below link to know how to use select method of datatable.

https://www.c-sharpcorner.com/UploadFile/0f68f2/querying-a-data-table-using-select-method-and-lambda-express/

https://stackoverflow.com/questions/16767010/c-sharp-datatable-select-how-do-i-format-the-filter-criteria-to-include-null

Hope it helps you.

Thanks.
+2