two combox with three textbox two tables populate bases on c

Question

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.

Hiten Pandya · 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.

Hiten Pandya · Answer

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.

Hiten Pandya · Answer

Hi Ifraz Imanudeen, Thank you for accepting the answer. Glad that code works for you and you got your solutions. Happy Coding :D Thanks.

Ifraz Imanudeen · Answer

Thank you very much Hiten Pandya . Solved all my issues.

Ifraz Imanudeen · Answer

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 { 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

two combox with three textbox two tables populate bases on c

Answers (5)