searching in datagridview

Question

hello sir i m facing a problem to searching in datagrid view on selected change on drop down list . please provide code . Thnks

Sanjay Kumar · Answer

HI windows application / web ? try this private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection conn = new SqlConnection(@server = .\sql2012; integrated security = true; // Select query string sqlSelect = SELECT FIRST_NAMELAST_NAME FROM EmpLogin WHERE EID= + comboBox1.SelectedIndex + ; SqlCommand cmd = new SqlCommand(sqlSelect conn); try { SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (reader.HasRows) { txtFirstName.Text = reader[0].ToString(); txtLastName.Text = reader[1].ToString(); } else { MessageBox.Show(This ID does not exist); } } catch (SqlException ex) { MessageBox.Show(ex.Message + ex.StackTrace Exception Details); } finally { conn.Close(); } }

Rajeev Kumar · Answer

i am working on web.

Abhay Shanker · Answer

please explain your requirement