Display data in DataGridview using ComboBox in c#

Question

Sir I am doing a ADO.NET program in C#. Firstly I am Introducing My form to you:- frmTeacherSearch You can see Nos'12' in combobox. These are the employeeId of teachers saved in tbl_Teachers. I saved these data from another form named frm_Teacher. now I want to retrieve that files to the datagridView1 in frmTeacherSearch. I want only employeeNamejoinDate and Designation to be filled in the dataGrid. when I select 1 in combobox I want to show the employeeName joinDate and Designation whom has employeeId 1. A filteration is what i am trying to function here. so If you want more my program data(classes database/table) i will provide you. I hope that you will solve this.

Iftikar Hussain · Answer

try this private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { if (cmbSearchBy.SelectedIndex > -1) { //decimal empId = Convert.ToDecimal(cmbSearchBy.SelectedItem); DataRowView dataRow = cmbSearchBy.SelectedItem as DataRowView; var empId = dataRow.Row.ItemArray[0]; if (Drow != null) { DataSet ds = new DataSet(); if (conn.State == ConnectionState.Closed) conn.Open(); string ambi1 = Select * FROM tbl_Teacher WHERE employeeId=@employeeId; SqlCommand cmd = new SqlCommand(ambi1 conn); cmd.Parameters.AddWithValue(@employeeId empId); SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(ds); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); dgvEmployeeStatus.DataSource = ds; } } } Regards Iftikar

Bineesh VP · Answer

Sir Still I in error. Here my code; private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { if (cmbSearchBy.SelectedIndex > -1) { //decimal empId = Convert.ToDecimal(cmbSearchBy.SelectedItem); DataRowView Drow = cmbSearchBy.SelectedItem as DataRowView; if (Drow != null) { 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 tbl_Teacher WHERE employeeId=@employeeId; SqlCommand cmd = new SqlCommand(ambi1 conn); cmd.Parameters.AddWithValue(@employeeId Drow); SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(ds); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } dgvEmployeeStatus.DataSource = ds; } } } here the error window appearing in my program.

Iftikar Hussain · Answer

Please provide your code for cmbSearchBy_SelectedIndexChanged Regards Iftikar

Bineesh VP · Answer

Sir we again in error here is the code. please send the solution as full code . here is the current error.

Iftikar Hussain · Answer

try this it will work now private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { DataRowView dataRow = comboBox1.SelectedItem as DataRowView; if (dataRow != null) { var empId = dataRow.Row.ItemArray[0]; // your code } } Regards Iftikar

Bineesh VP · Answer

Sir Still I am far from the output. I tried a bit to solve the error but I am an infant in the .Net World. here is my new error:- I think I am very near to the result of my program

Iftikar Hussain · Answer

put the break point and check the value for empId and name private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { var empId = comboBox1.Text; var name = comboBox1.SelectedValue; } Regards Iftikar

Bineesh VP · Answer

Sir I added the code in your reply. there is no error but the program doesn't give the result I expects. either no error nor any results

Sanjeeb Lenka · Answer

try this private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { if( cmbSearchBy .SelectedIndex > -1) { int empId = Convert.ToInt32( cmbSearchBy .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 tbl_teacher WHERE employeeId =@Teacherid; SqlCommand cmd = new SqlCommand(ambi1 conn); cmd.Parameters.AddWithValue(@Teacherid empId); SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(ds); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } dataGridView1.DataSource = ds; } }

Iftikar Hussain · Answer

Hi Try like this private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { var empId= cmbSearchBy. Text; //your sql code to fecth data from table } Regards Iftikar

Bineesh VP · Answer

Here is my frmteacherSearch Code:- using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Configuration; using System.Data.SqlClient; namespace work { public partial class frmTeacherSearch : Form { public frmTeacherSearch() { InitializeComponent(); } private void cmbSearchBy_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { dtpFrom.Focus(); } if (e.KeyCode == Keys.Back) { btnClose.Focus(); } } private void dtpFrom_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { dtpTo.Focus(); } if (e.KeyCode == Keys.Back) { cmbSearchBy.Focus(); } } private void dtpTo_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { btnClose.Focus(); } } private void btnClose_Click(object sender EventArgs e) { if (MessageBox.Show(Do You want to Quit? Message MessageBoxButtons.YesNo MessageBoxIcon.Question) == DialogResult.Yes) { this.Close(); } } public void comboFill() { DataTable d = new DataTable(); teacherSP spteacher = new teacherSP(); d = spteacher.teacherviewAll(); DataRow r = d.NewRow(); r[1] = -SELECT-; d.Rows.InsertAt(r 0); cmbSearchBy.DataSource = d; cmbSearchBy.ValueMember = employeeName; cmbSearchBy.DisplayMember = employeeId; } private void frmTeacherSearch_Load(object sender EventArgs e) { comboFill(); } private void cmbSearchBy_SelectedIndexChanged(object sender EventArgs e) { //as the code not working  I not used in this program } } }

Iftikar Hussain · Answer

Hi. Please provide the code for frmTeacherSearch. So that I can give you query for your requirements. Regards Iftikar