GridView DataSource Is Nothing

[=?Utf-8?B?U0FM?=]

I am trying to cast my Gridview in my Code behide as a Dataset so I can
manipulate the data. Here is the code snippet:

Dim FilteredDataSet As New System.Data.Dat aSet

Dim gv As New GridView
gv = CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView)
gv.GridLines = GridLines.Both
gv.DataBind()
FilteredDataSet = DirectCast(gv.D ataSource, System.Data.Dat aSet)
Now the issue I'm running into is the gv.DataSource is Nothing. My
GridView_1 control which I assign my gv to is bound to a <asp:SqlDataSou rce
ID="SqlDataSour ce1on the HTML side and loads GridView_1 fine. Even if I
assign the gv.DataSource as "gv.DataSou rce =
CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView).DataS ource", the
DataSource still shows nothing. When I check
CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView).DataS ourceID the is
shows SqlDataSource1.

Can anyone tell why my GridView_1 gets populated just fine but the
DataSource shows NOTHING, which is preventing me from creating a DataSet from
my GridView? If my syntax is wrong can you show me how to fix it?

Thanks,

[Munna]

Hi,

First assign a dataset as a data source of the grid..
then try to cast...

Regards

Munna

[Ben Schwehn]

Dim gv As New GridView

I believe this should better be

Dim gv As GridView

gv = CType(tbl_Repor tData.FindContr ol("GridView_1" ),

Can anyone tell why my GridView_1 gets populated just fine but the
DataSource shows NOTHING, which is preventing me from creating a DataSet
from my GridView?

Possibly because you're trying to access the DataSource property before it
has been set. Is it still nothing in say Page_PreRender or
GridView_1_OnDa taBound?

--
Ben | bschwehn.de

[=?Utf-8?B?U0FM?=]

Yes, the PreRender shows it as NOTHING. I Changed the declaration to Dim gv
as GridView as you suggested but it didn't work.

"Ben Schwehn" wrote:

Dim gv As New GridView

I believe this should better be

Dim gv As GridView

gv = CType(tbl_Repor tData.FindContr ol("GridView_1" ),

Can anyone tell why my GridView_1 gets populated just fine but the
DataSource shows NOTHING, which is preventing me from creating a DataSet
from my GridView?

Possibly because you're trying to access the DataSource property before it
has been set. Is it still nothing in say Page_PreRender or
GridView_1_OnDa taBound?

--
Ben | bschwehn.de

[=?Utf-8?B?U0FM?=]

The problem is, I can't assign the DataSet to the GridView_1 DataSource
because CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView).DataS ource
also returns NOTHING. GridView_1 gets rendered because it's DataSourceID is
assigned to <asp:SqlDataSou rce ID="SqlDataSour ce1>.

"Munna" wrote:

Hi,

First assign a dataset as a data source of the grid..
then try to cast...

Regards

Munna

[=?Utf-8?B?U0FM?=]

I'm not 100% certain of this, but is it possible that when you set the
DataSourceID on your Gridview to a <asp:SqlDataSou rceor
<asp:ObjectData Sourcethat the your DataSource of your Gridview will return
NOTHING?

"SAL" wrote:

I am trying to cast my Gridview in my Code behide as a Dataset so I can
manipulate the data. Here is the code snippet:

Dim FilteredDataSet As New System.Data.Dat aSet

Dim gv As New GridView
gv = CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView)
gv.GridLines = GridLines.Both
gv.DataBind()
FilteredDataSet = DirectCast(gv.D ataSource, System.Data.Dat aSet)
Now the issue I'm running into is the gv.DataSource is Nothing. My
GridView_1 control which I assign my gv to is bound to a <asp:SqlDataSou rce
ID="SqlDataSour ce1on the HTML side and loads GridView_1 fine. Even if I
assign the gv.DataSource as "gv.DataSou rce =
CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView).DataS ource", the
DataSource still shows nothing. When I check
CType(tbl_Repor tData.FindContr ol("GridView_1" ), GridView).DataS ourceID the is
shows SqlDataSource1.

Can anyone tell why my GridView_1 gets populated just fine but the
DataSource shows NOTHING, which is preventing me from creating a DataSet from
my GridView? If my syntax is wrong can you show me how to fix it?

Thanks,

[Ben Schwehn]

On Thu, 31 Jul 2008 11:11:01 -0700, SAL wrote:

Yes, the PreRender shows it as NOTHING.

Right, sorry.
When you're using a SqlDataSource and bind it via the DataSourceId, the
DataSource property just is not set. Also there isn't even a DataSet
involved, that you could get.

But you can get a *DataView* by calling the Select method on your
SqlDataSource like

TheSqlDataSourc e.Select(DataSo urceSelectArgum ents.Empty);

As an alternative you could always just use old style databinding w/o
DataSourceId.

I Changed the declaration to
Dim gv as GridView as you suggested but it didn't work.

That was an unrelated problem, your code just created a new GridView
object for no good reason.

[=?Utf-8?B?U0FM?=]

Thanks for the info Ben it makes sense now. You are right, having "As New
GridView" was overkill but I had it there because I thought maybe I was
missing something which it's clear that I wasn't.

What did you mean by "As an alternative you could always just use old style
databinding w/o DataSourceId"? I am assuming you mean to set the DataSource
of the GridView in the Code behind prior to Rendering the Gridview.
"Ben Schwehn" wrote:

On Thu, 31 Jul 2008 11:11:01 -0700, SAL wrote:

Yes, the PreRender shows it as NOTHING.

Right, sorry.
When you're using a SqlDataSource and bind it via the DataSourceId, the
DataSource property just is not set. Also there isn't even a DataSet
involved, that you could get.

But you can get a *DataView* by calling the Select method on your
SqlDataSource like

TheSqlDataSourc e.Select(DataSo urceSelectArgum ents.Empty);

As an alternative you could always just use old style databinding w/o
DataSourceId.

I Changed the declaration to
Dim gv as GridView as you suggested but it didn't work.

That was an unrelated problem, your code just created a new GridView
object for no good reason.