Simple(?) DataView Question

[Martin Schmid]

I am trying to implement a DataView for a DataGrid so I can sort at runtime
by clicking on column headers. My initial page load works... it displays
the data However, when I click a column heading at run time, the data
doesn't sort as expected, in fact, the DataGrid becomes empty, all I see are
column headings:

SqlConnection sqlConnection;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected ProjContMan.dsProjByDate dsProjByDate;
protected System.Data.DataView dataView;
SqlDataAdapter sqlDataAdapter;
private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection = (SqlConnection)Session["sqlConnection"];
sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];
if(!IsPostBack)
{
sqlDataAdapter.Fill(dsProjByDate);
DataGrid1.DataSource=dataView;
DataGrid1.DataBind();
}
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
dataView.Sort=e.SortExpression;
DataGrid1.DataBind();
}


--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE

[Nicholas Paldino [.NET/C# MVP]]

Martin,

Do you have the viewstate enabled on the page? If you do not, then the
data on the grid will not be post back to the page for repopulation (you are
filling the grid only when it is not a postback, so that is why the grid is
empty).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am trying to implement a DataView for a DataGrid so I can sort at runtime by clicking on column headers. My initial page load works... it displays
the data However, when I click a column heading at run time, the data
doesn't sort as expected, in fact, the DataGrid becomes empty, all I see are column headings:

SqlConnection sqlConnection;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected ProjContMan.dsProjByDate dsProjByDate;
protected System.Data.DataView dataView;
SqlDataAdapter sqlDataAdapter;
private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection = (SqlConnection)Session["sqlConnection"];
sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];
if(!IsPostBack)
{
sqlDataAdapter.Fill(dsProjByDate);
DataGrid1.DataSource=dataView;
DataGrid1.DataBind();
}
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
dataView.Sort=e.SortExpression;
DataGrid1.DataBind();
}


--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE

[Martin Schmid]

EnableViewState for DataGrid1 is true, as is enableViewState for DOCUMENT.

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:O6**************@TK2MSFTNGP11.phx.gbl...

Martin,

Do you have the viewstate enabled on the page? If you do not, then the data on the grid will not be post back to the page for repopulation (you are filling the grid only when it is not a postback, so that is why the grid is empty).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am trying to implement a DataView for a DataGrid so I can sort at

runtime

by clicking on column headers. My initial page load works... it displays the data However, when I click a column heading at run time, the data
doesn't sort as expected, in fact, the DataGrid becomes empty, all I see

are

column headings:

SqlConnection sqlConnection;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected ProjContMan.dsProjByDate dsProjByDate;
protected System.Data.DataView dataView;
SqlDataAdapter sqlDataAdapter;
private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection = (SqlConnection)Session["sqlConnection"];
sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];
if(!IsPostBack)
{
sqlDataAdapter.Fill(dsProjByDate);
DataGrid1.DataSource=dataView;
DataGrid1.DataBind();
}
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
dataView.Sort=e.SortExpression;
DataGrid1.DataBind();
}


--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE

[Nicholas Paldino [.NET/C# MVP]]

Martin,

When you look at the page that is sent to the browser, do you see the
viewstate persisted to the page in a hidden form field?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:ea**************@TK2MSFTNGP10.phx.gbl...

EnableViewState for DataGrid1 is true, as is enableViewState for DOCUMENT.

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in message news:O6**************@TK2MSFTNGP11.phx.gbl...

Martin,

Do you have the viewstate enabled on the page? If you do not, then

the

data on the grid will not be post back to the page for repopulation (you

are

filling the grid only when it is not a postback, so that is why the grid

is

empty).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am trying to implement a DataView for a DataGrid so I can sort at

runtime

by clicking on column headers. My initial page load works... it displays the data However, when I click a column heading at run time, the data
doesn't sort as expected, in fact, the DataGrid becomes empty, all I

see are

column headings:

SqlConnection sqlConnection;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected ProjContMan.dsProjByDate dsProjByDate;
protected System.Data.DataView dataView;
SqlDataAdapter sqlDataAdapter;
private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection = (SqlConnection)Session["sqlConnection"];
sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];
if(!IsPostBack)
{
sqlDataAdapter.Fill(dsProjByDate);
DataGrid1.DataSource=dataView;
DataGrid1.DataBind();
}
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
dataView.Sort=e.SortExpression;
DataGrid1.DataBind();
}


--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE

[Martin Schmid]

I have revised my code as follows... but I don't understand what is going on
yet. Do I have any redundancies ... any explanation is helpful!
SqlConnection sqlConnection;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected ProjContMan.dsProjByDate dsProjByDate;
protected System.Data.DataView dataView;
SqlDataAdapter sqlDataAdapter;
private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection = (SqlConnection)Session["sqlConnection"];
sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];

if(!IsPostBack)
{
DataGrid1.DataSource=dataView;
}
sqlDataAdapter.Fill(dataView.Table);
DataGrid1.DataBind();
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
dataView.Sort=e.SortExpression;
DataGrid1.DataBind();
}


--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:uY**************@TK2MSFTNGP12.phx.gbl...

Martin,

When you look at the page that is sent to the browser, do you see the
viewstate persisted to the page in a hidden form field?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:ea**************@TK2MSFTNGP10.phx.gbl...

EnableViewState for DataGrid1 is true, as is enableViewState for DOCUMENT.

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote

in

message news:O6**************@TK2MSFTNGP11.phx.gbl...

Martin,

Do you have the viewstate enabled on the page? If you do not, then

the

data on the grid will not be post back to the page for repopulation

(you are

filling the grid only when it is not a postback, so that is why the

grid is

empty).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Martin Schmid" <ma**********@sbcglobal.net.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> I am trying to implement a DataView for a DataGrid so I can sort at
runtime
> by clicking on column headers. My initial page load works... it

displays

> the data However, when I click a column heading at run time, the

data > doesn't sort as expected, in fact, the DataGrid becomes empty, all I

see are
> column headings:
>
> SqlConnection sqlConnection;
> protected System.Web.UI.WebControls.DataGrid DataGrid1;
> protected ProjContMan.dsProjByDate dsProjByDate;
> protected System.Data.DataView dataView;
> SqlDataAdapter sqlDataAdapter;
>
>
> private void Page_Load(object sender, System.EventArgs e)
> {
> sqlConnection = (SqlConnection)Session["sqlConnection"];
> sqlDataAdapter = (SqlDataAdapter)Session["sqlDataAdapter"];
> if(!IsPostBack)
> {
> sqlDataAdapter.Fill(dsProjByDate);
> DataGrid1.DataSource=dataView;
> DataGrid1.DataBind();
> }
> }
>
>
> private void DataGrid1_SortCommand(object source,
> System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
> {
> dataView.Sort=e.SortExpression;
> DataGrid1.DataBind();
> }
>
>
>
>
> --
> Thanks,
> Martin Schmid, EIT, CCSA, MCDBA, MCSE
>
>