searching in datagridview

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_NAME,LAST_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();
     }
        }