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




Reply With Quote