How Do I Populate Detailview With Textbox

See more:

VB

ASP

I am trying to populate a detailview based on textbox value. I get @txtname need to be declared. When I run the page.

Protected Sub txtName_TextChanged(sender As Object, e As EventArgs) Handles txtName.TextChanged
     
      Dim con As SqlConnection = New SqlConnection("Data Source=HSE-SQL-01;Initial Catalog=Inspections;Integrated Security=True")
      Dim cmd As SqlCommand = New SqlCommand("SELECT DISTINCT * FROM [tbl_lat sewerconnection] WHERE ([LotAddress] = @txtName)", con)
      cmd.Parameters.AddWithValue("@Id", ID)
      'id is your value retrieved from textbox.
      Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
      Dim ds As DataSet = New DataSet()
      da.Fill(ds)
      'now bind the datasource with DeailsView Control.
      DetailsView1.DataSource = ds
      DetailsView1.DataBind()

vb.net code above



  End Sub

textbox declaration

<asp:TextBox ID="txtName" runat="server"></asp:TextBox>



    <asp:AutoCompleteExtender ID="txtName_AutoCompleteExtender" runat="server"
        DelimiterCharacters="" Enabled="True" ServicePath=""
        TargetControlID="txtName" MinimumPrefixLength="2" CompletionInterval="1000"
        EnableCaching="false" FirstRowSelected="false" CompletionSetCount= "100" ServiceMethod="GetCompletionList"
        UseContextKey="True">
    </asp:AutoCompleteExtender>