Data in dataset but not displaying in gridview

[kjewell23]

Hello, I'm new to this asp.net 2.0 I need help??
My database is coming from AS400 which uses odbc Commands. i have data in the dataset but nothing showing in my gridview. However the data does show on the page. Could you please see what I'm doing wrong.

My code is down below

 Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
 
 
        Dim myconnection As OdbcConnection
        Dim myCommand As OdbcDataAdapter
        Dim mydataset As New DataSet
        Dim gvResults As DataTable
        Dim loop1 As Integer
        Dim numrows As Integer
        Dim mysql As String
        Dim Order As Integer
        Order = CInt(txtOrderNumber.Text)
 
 
        mysql = "select  line#, ordno, quano, quana, quans, c2rdt, unitm, prdno, actsp  from rmsfiles2.obcop200 where ordno = " & Order
        myconnection = New OdbcConnection("DRIVER=Client Access ODBC Driver (32-bit);UID=ODBC;PWD=XXXXX;System=xxx.xxx.xxx.xxx")
 
        myCommand = New OdbcDataAdapter(mysql, myconnection)
 
        myCommand.Fill(mydataset, "OBCOP200")
 
        gvResults = New DataTable
        gvResults = mydataset.Tables(0)
 
        numrows = gvResults.Rows.Count
 
        If numrows = 0 Then
            txtOrderNumber.Text = "Order#" & txtOrderNumber.Text & " invalid order number"
 
        Else
            txtOrderNumber.Text = ""
 
            For loop1 = 0 To numrows - 1
 
                Response.Write(Server.HtmlEncode(gvResults.Rows(loop1).Item("ordno")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quano")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quana")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quans")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("c2rdt")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("unitm")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("prdno")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("actsp")) & " <br>")
 
 
            Next loop1
            gridview1.DataBind()
        End If
 
        gridview1.DataSource = mydataset.Tables("OBCOP200").DefaultView
        gridview1.DataBind()
        gridview1.Visible = True

[Frinavale]

Ok I try it. Nothing comes up when I do a number however when I type in name it comes up with please supply a valid number. What should we do

I suggest starting a new project and learning how to use the GridView object before continuing with what you are doing.

MSDN has a library on everything you would like to know about .NET.
See the MSDN article on the GridView Class. Near the bottom there are links to a whole bunch of walkthoughs that will help you learn this object. Farther down in the article there is an example.

So I suggest starting a new project with just one aspx page in...and a GridView object (and label that you can use to display errors).

Once you can get data to appear in your GridView, try adding in the database stuff.

-Frinny

[Frinavale]

This thread has a section removed from it.
See the thread on
'MachineToApplication' beyond application level Error for the part that has been removed.