Member Avatar for Mike Bishop

I want to search through an sql table called hardware for a partial serial numbers.

I have the following code but there is something wrong with the way i am doing my
sql query. hope someone out there can help me.

Public Function GetDatabysn() As DataView
        Dim SelectQry = "SELECT * FROM hardware where serial= like %'" & Me.TextBox1.Text & " %'"
        Dim SampleSource As New DataSet
        Dim TableView As DataView
        Try
            Dim SampleCommand As New SqlCommand()
            Dim SampleDataAdapter = New SqlDataAdapter()
            SampleCommand.CommandText = SelectQry
            SampleCommand.Connection = Connection
            SampleDataAdapter.SelectCommand = SampleCommand
            SampleDataAdapter.Fill(SampleSource)
            TableView = SampleSource.Tables(0).DefaultView
        Catch ex As Exception
            Throw ex
        End Try
        Return TableView
    End Function
  • 1 Contributor
  • 1 Reply
  • 4K Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Mike Bishop
Member Avatar for Mike Bishop

hi everyone one i have sorted it with the following code

Dim SelectQry = "SELECT * FROM hardware where serial like'%" & Me.TextBox1.Text & "%'"

        Dim SampleSource As New DataSet
        Dim TableView As DataView
        Try
            Dim SampleCommand As New SqlCommand()
            Dim SampleDataAdapter = New SqlDataAdapter()
            SampleCommand.CommandText = SelectQry
            SampleCommand.Connection = Connection
            SampleDataAdapter.SelectCommand = SampleCommand
            SampleDataAdapter.Fill(SampleSource)
            TableView = SampleSource.Tables(0).DefaultView
        Catch ex As Exception
            Throw ex
        End Try
        Return TableView
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.