<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" />
        <br />
        <br />
        <asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate><table width="100%"><tr><th>Name</th><th>City</th></tr></HeaderTemplate>
        <ItemTemplate>
        <tr><td><%#DataBinder.Eval(Container.DataItem, "Name")%></a></td>
        <td><%#DataBinder.Eval(Container.DataItem, "Standort")%></td></tr>
        </ItemTemplate>
        <FooterTemplate></table></FooterTemplate>
        </asp:Repeater>

ALTER PROCEDURE spSearchString
@SearchString varchar(50)
AS
SELECT tbl_ersatzbeschaffung.Name, tbl_ersatzbeschaffung.Standort
FROM tbl_ersatzbeschaffung
WHERE (tbl_ersatzbeschaffung.Name LIKE '%' + @SearchString + '%' OR _
  tbl_ersatzbeschaffung.Standort LIKE '%' + @SearchString + '%')
RETURN

Imports System.Data.SqlClient
Imports System.Data
 
Partial Class _Default
    Inherits System.Web.UI.Page
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As _
      System.EventArgs) Handles Me.Load
        If Request.QueryString("searchString") IsNot Nothing Then
            DisplaySearchResults(Request.QueryString("searchString"))
        End If
    End Sub
 
    Public Sub DisplaySearchResults(ByVal strSearch As String)
 
        Dim cmd As New SqlCommand("spSearchString", New SqlConnection( _
          ConfigurationManager.AppSettings("ConnString")))
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Parameters.AddWithValue("@SearchString", strSearch)
        cmd.Connection.Open()
 
        Repeater1.DataSource = cmd.ExecuteReader()
        Repeater1.DataBind()
 
        cmd.Connection.Close()
        cmd.Connection.Dispose()
    End Sub
 
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
        Response.Redirect("Default.aspx?searchString=" & Server.UrlEncode( _
          TextBox1.Text))
    End Sub
 
End Class