combobox Selected Item to be display in DatagridView

Question

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 employeeNamejoiningDate and Designation. please help me in this topic.

Muralidharan Deenathayalan · Answer

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 Hussain · Answer

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 VP · Answer

I did exactly u said but I am getting an error. please explain the cause and for this error. here my error:-

Muralidharan Deenathayalan · Answer

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 Hussain · Answer

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 Lenka · Answer

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