I have a datagrid on a web form and I am setting the datasource in Page_Load
Event and there are no errors generated, I can interrogate the DataTable and
it returns row count, column count, data in rows, etc., but the DataGrid
itself will NOT appear at all on the web form. Anybody know why?

Thanks.

Joe
**********************

Dim oConn As New OleDbConnection
oConn.ConnectionString = ConnString 'generated outside Page_Load
oConn.Open()

Dim sSQL As String = "select * from REGISTRATION"

Dim da As OleDbDataAdapter = New OleDbDataAdapter(sSQL, oConn)

Dim ds As DataSet = New DataSet
da.Fill(ds, "REGISTRATION")
Me.DataGrid1.DataSource = ds.Tables("REGISTRATION")
lblStatus.Text = ds.Tables(0).TableName & ";Columns = " &
ds.Tables(0).Columns.Count.ToString
lblStatus.Visible = True

--
Joe Baker

Add this to the end:

DataGrid1.DataBind



"Joe" <(E-Mail Removed)> wrote in message
news:567F1594-AA83-4EED-B89A-(E-Mail Removed)...
>I have a datagrid on a web form and I am setting the datasource in
>Page_Load
> Event and there are no errors generated, I can interrogate the DataTable
> and
> it returns row count, column count, data in rows, etc., but the DataGrid
> itself will NOT appear at all on the web form. Anybody know why?
>
> Thanks.
>
> Joe
> **********************
>
> Dim oConn As New OleDbConnection
> oConn.ConnectionString = ConnString 'generated outside Page_Load
> oConn.Open()
>
> Dim sSQL As String = "select * from REGISTRATION"
>
> Dim da As OleDbDataAdapter = New OleDbDataAdapter(sSQL, oConn)
>
> Dim ds As DataSet = New DataSet
> da.Fill(ds, "REGISTRATION")
> Me.DataGrid1.DataSource = ds.Tables("REGISTRATION")
> lblStatus.Text = ds.Tables(0).TableName & ";Columns = " &
> ds.Tables(0).Columns.Count.ToString
> lblStatus.Visible = True
>
> --
> Joe Baker

Actually, to be more precise:

If Not IsPostBack Then
DataGrid1.DataBind
End If


"Scott M." <s-(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Add this to the end:
>
> DataGrid1.DataBind
>
>
>
> "Joe" <(E-Mail Removed)> wrote in message
> news:567F1594-AA83-4EED-B89A-(E-Mail Removed)...
>>I have a datagrid on a web form and I am setting the datasource in
>>Page_Load
>> Event and there are no errors generated, I can interrogate the DataTable
>> and
>> it returns row count, column count, data in rows, etc., but the DataGrid
>> itself will NOT appear at all on the web form. Anybody know why?
>>
>> Thanks.
>>
>> Joe
>> **********************
>>
>> Dim oConn As New OleDbConnection
>> oConn.ConnectionString = ConnString 'generated outside Page_Load
>> oConn.Open()
>>
>> Dim sSQL As String = "select * from REGISTRATION"
>>
>> Dim da As OleDbDataAdapter = New OleDbDataAdapter(sSQL, oConn)
>>
>> Dim ds As DataSet = New DataSet
>> da.Fill(ds, "REGISTRATION")
>> Me.DataGrid1.DataSource = ds.Tables("REGISTRATION")
>> lblStatus.Text = ds.Tables(0).TableName & ";Columns = " &
>> ds.Tables(0).Columns.Count.ToString
>> lblStatus.Visible = True
>>
>> --
>> Joe Baker
>
>

ah, yes. It's the simple things... that worked. Thanks Scott.

"Scott M." wrote:

> Actually, to be more precise:
>
> If Not IsPostBack Then
> DataGrid1.DataBind
> End If
>
>
> "Scott M." <s-(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Add this to the end:
> >
> > DataGrid1.DataBind
> >
> >
> >
> > "Joe" <(E-Mail Removed)> wrote in message
> > news:567F1594-AA83-4EED-B89A-(E-Mail Removed)...
> >>I have a datagrid on a web form and I am setting the datasource in
> >>Page_Load
> >> Event and there are no errors generated, I can interrogate the DataTable
> >> and
> >> it returns row count, column count, data in rows, etc., but the DataGrid
> >> itself will NOT appear at all on the web form. Anybody know why?
> >>
> >> Thanks.
> >>
> >> Joe
> >> **********************
> >>
> >> Dim oConn As New OleDbConnection
> >> oConn.ConnectionString = ConnString 'generated outside Page_Load
> >> oConn.Open()
> >>
> >> Dim sSQL As String = "select * from REGISTRATION"
> >>
> >> Dim da As OleDbDataAdapter = New OleDbDataAdapter(sSQL, oConn)
> >>
> >> Dim ds As DataSet = New DataSet
> >> da.Fill(ds, "REGISTRATION")
> >> Me.DataGrid1.DataSource = ds.Tables("REGISTRATION")
> >> lblStatus.Text = ds.Tables(0).TableName & ";Columns = " &
> >> ds.Tables(0).Columns.Count.ToString
> >> lblStatus.Visible = True
> >>
> >> --
> >> Joe Baker
> >
> >
>
>
>