[RESOLVED] Strange SQL Problem

[Strider]

Im connecting to a remote sqlserver database from my web application. however when i connect and retrieve the info from the database i try to assign it to a datagrid but when i run the web application the datagrid cannot be seem.

i have not set visible = false

and i can assign data from within the dataset to labels etc its just the table is not visible

Dim sqlstmt As String = "SELECT * FROM tblStatus"
        Dim conn As New System.Data.SqlClient.SqlConnection("server=xxx.xxx.xxx.xxx;uid=xxxx;pwd=xxxx;database=xxxx")
        Dim sqlcmd As New System.Data.SqlClient.SqlCommand(sqlstmt, conn)
        Dim da As New System.Data.SqlClient.SqlDataAdapter(sqlcmd)
        Dim ds As New DataSet
        da.Fill(ds, "tblStatus")
        'lblMissingData.Text = ds.Tables(0).Rows.Count
        DataGrid1.DataSource() = ds
        DataGrid1.Visible = True

[mendhak]

DataGrid1.DataBind();

[hellswraith]

As said above, but with this as well:
DataGrid1.DataSource = ds.Tables("tblStatus")
DataGrid1.DataBind()