Pulling the Dataset from a Datagrid

[John Scott]

I was just wondering if it's possible to cast a datagrid DataSource as a
DataSet?

I've stepped through my code when the grid is first being bound and the
DataSource shows up as a DataSet for the datagrid. Then, when I handle on
OnClick event for an image button and the page posts back, I look at the
DataSource for the grid and it says it's null. Is there any way of getting
the grid's current datasource after it loads?

I've tried this exact snipit of code:
DataSet ds = (DataSet)dgResults.DataSource; ....but this is where it says
the DataSource is null.

I want to be able to pull the datasource into a dataset, add a new row to
the dataset and rebind the datagrid showing a new blank row in the grid.

Any help would be appreciated.
--
Thanks in advance,

John Scott.

[Andreas.Knudsen(AT)bekk.no]

"John Scott" wrote:

I was just wondering if it's possible to cast a datagrid DataSource as a
DataSet?

I've stepped through my code when the grid is first being bound and the
DataSource shows up as a DataSet for the datagrid. Then, when I handle on
OnClick event for an image button and the page posts back, I look at the
DataSource for the grid and it says it's null. Is there any way of getting
the grid's current datasource after it loads?

I've tried this exact snipit of code:
DataSet ds = (DataSet)dgResults.DataSource; ....but this is where it says
the DataSource is null.

I want to be able to pull the datasource into a dataset, add a new row to
the dataset and rebind the datagrid showing a new blank row in the grid.

what happens is that the dataset is "forgotten" on each postback.
The only reason why you see data at all in the grid is because of the
viewstate preserving it. The viewstate only preserves the data though, not
where its coming from. so you go from having the data in a dataset (relations
etc) to having just the raw data in a table.

The "cure" would be to store the dataset on the session by using

Session["somekey"] = myDataSet;

for example at the end of the pageload ( if(!IsPostBack) )

then retrieving it when you need it

(if( myDataSet == null ) { myDataSet = Session["somekey"] as DataSet; }

after doing this you are left with your original dataset. modify it and do a
databind again and you should be set

mvh
Andreas