combobox Selected Item to be display in DatagridView

Bineesh Viswanath

Sir, I am doing a ADO.NET Program at the moment.

In my form, there is form named frmTeacher.

I filled its table called tbl_Teacher using frmTeacher form.

there is another form called frmTeacherSearch.

this form is for viewing the data of tbl_teacher(using condition where employeeId=@employeeId)

this form has a combobox and a gridview.

this is my form:-

The purpose of this form:-

combobox: employeeId from tbl_Teacher to be filled in it on form_LoadEvent().

You can see i did the code for load the employeeId.

Now my need is to fill datagridview1 with the related data that I select in combobox.

i.e , when I select 1, datagridview1 to be filled the combobox selected index's employeeName,joiningDate and Designation.

please help me in this topic.

6 Replies

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

13y ago
The return type of the ComboBox.SelectedItem is object. So you need to typecast before adding into parameter list. To get the value from combobox,
var empId = cmbSearchBy.Items[cmbSearchBy.SelectedIndex]

Later to do typecast before adding into sql param list.
Iftikar Hussain13y ago
can you check weather you are getting correct emp id value when selected index is changed. put break point and check. also execute the sql query by passing the same emp id value directly in your sql management studio

Regards,
Iftikar
Bineesh Viswanath13y ago
I did exactly u said, but I am getting an error.

please explain the cause and for this error.

here my error:-
13y ago
Hi,
I hope you're going right path.

On the combobox selected index change event, fetch the currently selected item text, and connect the database, fetch the information, fill into the dataset (datatable) and bind into the gridview.
Iftikar Hussain13y ago
Hi,
You can achieve this by handling selected index changed event of the dropdown as shown below

just go to your form and double click the dropdown. The below event will be generate automatically

In your Form.cs

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
var empId = comboBox1.SelectedItem;
DataSet ds=new DataSet();
using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUserId;Password=MyPassword"))
{
if (conn.State == ConnectionState.Closed)
conn.Open();
string ambi1 = "Select * FROM Employees WHERE EmployeeID=@Field";
SqlCommand cmd = new SqlCommand(ambi1, conn);
cmd.Parameters.AddWithValue("@Field", empId);
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(ds);
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
dataGridView1.DataSource = ds;
}

Regards,
Iftikar
Sanjeeb Lenka13y ago
IN combox selectedIndexchanged wirte the code for getting the data from database and bind it to datagrid.

sample query:

select employeeName,joiningDate,Designation from Teacher where employeeId=@employeeId