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'1,2' 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 employeeName,joinDate 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 Viswanath · 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 Viswanath · 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 Viswanath · 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 Viswanath · 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 Viswanath · 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