Not sure what I did here, but I am not getting any results from the following code when run in a web environment. If I run the SQL statement in the Management Studio, I do get results, so somewhere in the code it is not getting the right info.

Code:
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim connection As New SqlConnection()
        connection.ConnectionString = "server=servername; database=test;User ID=publicweb;Password=userpass;Initial Catalog=DBName"
        Dim Adapter As SqlDataAdapter
        Dim ds As DataTable = New DataTable
        Image1.ImageUrl = "~/hauling/pics/" & TextBox1.Text & ".jpg"
        Adapter = New SqlDataAdapter("Select certno, primaryowner, andor, auxowner, Address, City, State, Zip, dated, equinename, yobirth, type, sex, color, face, special, brandlocation, regno FROM xfer where certno='" + TextBox1.Text + "'", connection)
        Adapter.Fill(ds)
        GridView1.DataSource = ds
        GridView1.DataBind()
        gridview2.datasource = ds
        GridView2.DataBind()

    End Sub
If you need the code for the gridview, let me know. Thanks for any help..