title: How to search records by dropdownlist using asp.net
body: <p>how to search records from dropdown list using asp.net and from that record I should open the table how the data is stored.
  For example: If I click avinash in dropdown list it should display what the data stored with avinash then I should open the link of avinash then it should go to another table how the data has been stored. Here is the code for the dropdown list.</p>
  
  <pre><code>     &lt;tr&gt;
          &lt;td style="width:120px;text-align:top" class="blue"&gt;OwnerDepartment:&lt;/td&gt;
           &lt;td class="auto-style9"&gt;&lt;asp:DropDownList ID="ddlOwnerDepartment" runat="server"
               onselectedindexchanged="DropDownList_SelectedIndexChanged" &gt;
                                                    &lt;/asp:DropDownList&gt;
                            &lt;/td&gt;
       &lt;/tr&gt;
  </code></pre>
  
  <p>and the view code for dropdownlist in aspx.vb</p>
  
  <pre><code>Private Sub DropDownList_SelectedIndexChanged(sender As Object, e As EventArgs)
      ddlOwnerDepartment.SelectedValue = DropdownList.SelectedItem.Value
  End Sub
  </code></pre>
  
  <p>can anyone help me to fix this code and how to link to next table.
  Thanks in advance!!!</p>