title: how to search records in sql server using vb.net
body: <p>sorry guys i am a new programmer of vb.net so i need some help. i am not familiar with sql  server, this is my code in inserting employee info. and it works fine, and my question is how to search this record using emp_id only</p>
  
  <pre><code>    Dim mycommand As SqlCommand
      myconnection = New SqlConnection("server=;uid=admin;pwd=;database=payroll")
      myconnection.Open()
      mycommand = New SqlCommand("INSERT INTO employee_info([employee_id],
        [first_name],[last_name],[middle_name],[email],[telephone],
        [gender],[status],[date_birth],[hire_date],[street_add],[city],
        [state_province]) values ('" &amp; Employee_idTextBox.Text &amp; "','" &amp;
        First_nameTextBox.Text &amp; "','" &amp; Last_nameTextBox.Text &amp; "','" &amp;
        Middle_nameTextBox.Text &amp; "','" &amp; EmailTextBox.Text &amp; "','" &amp;
        TelephoneTextBox.Text &amp; "','" &amp; GenderTextBox.Text &amp; "','" &amp; 
        StatusTextBox.Text &amp; "','" &amp; Date_birthDateTimePicker.Value.Date &amp; 
        "','" &amp; Hire_dateDateTimePicker.Value.Date &amp; "','" &amp; 
        Street_addTextBox.Text &amp; "','" &amp; CityTextBox.Text &amp; "','" &amp;
        State_provinceTextBox.Text &amp; "')", myconnection)
      mycommand.ExecuteNonQuery()
      myconnection.Close()
  </code></pre>