Oye Mjesus20 el parametro contra el piensas buscar es un texto que se tiene que tipear?
Si es asi
Yo hacia algo parecido buscaba en datagrid de acuerdo al nombre de cargo tipeado en un texbox
si te sirve asi te paso el codigo aca
<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
<html>
<head runat="server" ID="Head1">
<title>Search Box</title>
</head>
<script language="VB" runat="server">
Sub Get_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
Dim SelectCommand As String = "select * from Empleados where (Cargo = @Cargo)"
MyConnection = New SqlConnection("server=local\NetSDK;database=portal ;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter(SelectCommand, MyConnection)
MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@Cargo", SqlDbType.NVarChar, 50))
MyCommand.SelectCommand.Parameters("@Cargo").Value = txtSearch.text
DS = new DataSet()
MyCommand.Fill(DS,"Portal")
MyDataGrid.DataSource= DS.Tables("Portal").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body>
<form runat="server" ID="Form1">
<table bgcolor="aliceblue" width="271" height="147" align="center">
<tr>
<td align="middle">
<P>
<font color="#6699ff">BUSCADOR DEL BANCO EXTERIOR</font></P>
<P>
<asp:TextBox ID="txtSearch" Runat="Server" />
<input type="Button" OnServerClick="Get_Click" Value="buscar" runat="server" ID="Submit1" NAME="Submit1" />
<p>
<asp:RequiredFieldValidator ControlToValidate="txtSearch" Text="Introduzca la palabra clave" ValidationGroup="SearchGroup" SetFocusOnError="true" Runat="Server" ID="Requiredfieldvalidator1" />
</p>
<ASP:DataGrid id="MyDataGrid" runat="server" Width="700" BackColor="AliceBlue" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" EnableViewState="false" />
</td>
</tr>
</table>
</form>
</body>
</html>