C# .Net combobox selected item used as Input of a sql SP

Question

Hi All I am very new to .Net technology. I am working on a migration project where we are migrating PowerBuilder application to C# .Net windows application. I have created a windows form (UI) having 2 comboBox 1 CheckBox  1 DataGridView and a Search button used for fetching data in datagridview . I need to select an item in Combobox1 which automatically refreshes the items of the combobox2 . This two combobox uses SQL stored Procedure to work. And now checking the or un-checking the CheckBox will fetch and display the data in the DataGridView... Again fetching the data in datagridview uses a SQL Stored Procedure. Please help me resolving the issue. If my problem is not clear please drop me a mail at (akashsrivastava1205@gmail.com) so that I can explain the requirement in much details... Thanks Akash Srivastava.

Sujeet Suman · Answer

Akash please once follow below process: (01.) First create 3 different methods to execute your 3 different storedprocedures with your required i/p with return type is data reader. And on your form load bind your all 3 comtrols like- combobox1  combobox2 and dataGridView1. (02.) On combobox1 SelectedIndexChanged event rebind your combobox2. Pass combobox1 selected value as input to the storedprocedure through your method which you are using to bind combobox2. private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { // Rebind combobox2 } (03.) On Checkbox1 CheckedChanged evevt bind your DataGridView1. private void checkBox1_CheckedChanged(object sender EventArgs e) { // Renind dataGridView1 } If this is helpful for you then please accept my Answer .