[RESOLVED] Strange SQL Problem
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
VB Code:
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