ComboBox Droplist

Download my code and make necessary changes as per your database and run

Try the following assuming that you have done for the first i.e selecting a dropdown value and submitting. In your form that you would like to show the data create an object

public string optionType { get; set; }

also place a datagridview to show the data

In your main from i.e dropdown form on button click write this

// Replace as per needed here

Form3 frm3 = new Form3();
frm3.optionType = comboBox1.Text;
frm3.ShowDialog();

now in the form where you would like to show the data under form load code this

private void Form3_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnection);
SqlCommand cmd = new SqlCommand("select firstname from tblStudent where department='" + optionType + "'", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.AutoGenerateColumns = false;
}

hi,

thanks. but my situation is like this and would appreciate if you can show me howto do it.

i have database sql with 5 columns which is Emp ID, First Name , Last Name, Designation & Department.

I have created a window form with button (view) and combobox (droplist of the department which is added manually)

so, no i need to do the code for the button..if the user choose HR dept at the droplist and click the view button so the name list appear in messagebox..

so can you help if i need to get this date using sql database.

Thank you.

Is it winforms, First thing there is no Popup control in winforms, you need to create a form and code that form to display results when you select an item, by passing the selected item to the next form