sorting a datagrid in descending order

[Newbie]

i am able to allow the user to sort the columns of my datagrid, but only in
ascending order. is there a way to allow sorting in descending order? thanks
in advance.

private void Page_Load(objec t sender, System.EventArg s e)
{

string sTODS = "Select * From TaskOrder";
SqlConnection sqlConn = new SqlConnection(c onnStr);
SqlCommand sqlCMD = new SqlCommand(sTOD S);
sqlCMD.Connecti on = sqlConn;
sqlConn.Open();
SqlDataAdapter adapter = new SqlDataAdapter( sqlCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
dgSearchResults .DataSource = ds.Tables[0];
int tableRowCount = ds.Tables[0].Rows.Count;
if (tableRowCount != 0)
{
DataView dv = new DataView();
dv=ds.Tables[0].DefaultView;
Page.Session.Ad d("DataViewOrig inal",dv);
dgSearchResults .DataSource=dv;
dgSearchResults .DataBind();
dgSearchResults .Visible = true;
}
else
{
dgSearchResults .Visible = false;
}
}

private void dgSearchResults _SortCommand(ob ject source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
if(Page.Session["DataViewOrigin al"]!=null)
{
DataView dv=(DataView) Page.Session["DataViewOrigin al"];
dv.Sort=e.SortE xpression;
dgSearchResults .DataSource=dv; //assign the source
dgSearchResults .DataBind();
}
}

[Ignacio Machin \( .NET/ C# MVP \)]

hi

I don;t know how you are declaring the datagrid itself, but all you have
to do is add an ASC or DESC to the SortExpression.

IIRC the SortCommand of the datagrid does not allow to especify it, so you
may will need to find another approach or a work around. like keeping in
session the last kind of sorting you did and just do the opposite.

let me know if you need some ideas.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

i am able to allow the user to sort the columns of my datagrid, but only in
ascending order. is there a way to allow sorting in descending order?
thanks
in advance.

private void Page_Load(objec t sender, System.EventArg s e)
{

string sTODS = "Select * From TaskOrder";
SqlConnection sqlConn = new SqlConnection(c onnStr);
SqlCommand sqlCMD = new SqlCommand(sTOD S);
sqlCMD.Connecti on = sqlConn;
sqlConn.Open();
SqlDataAdapter adapter = new SqlDataAdapter( sqlCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
dgSearchResults .DataSource = ds.Tables[0];
int tableRowCount = ds.Tables[0].Rows.Count;
if (tableRowCount != 0)
{
DataView dv = new DataView();
dv=ds.Tables[0].DefaultView;
Page.Session.Ad d("DataViewOrig inal",dv);
dgSearchResults .DataSource=dv;
dgSearchResults .DataBind();
dgSearchResults .Visible = true;
}
else
{
dgSearchResults .Visible = false;
}
}

private void dgSearchResults _SortCommand(ob ject source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
if(Page.Session["DataViewOrigin al"]!=null)
{
DataView dv=(DataView) Page.Session["DataViewOrigin al"];
dv.Sort=e.SortE xpression;
dgSearchResults .DataSource=dv; //assign the source
dgSearchResults .DataBind();
}
}

[Newbie]

there are 8 columns (all sortable). i'm not sure using 8 session variables to
store everything is the way to go.

"Ignacio Machin ( .NET/ C# MVP )" wrote:

hi

I don;t know how you are declaring the datagrid itself, but all you have
to do is add an ASC or DESC to the SortExpression.

IIRC the SortCommand of the datagrid does not allow to especify it, so you
may will need to find another approach or a work around. like keeping in
session the last kind of sorting you did and just do the opposite.

let me know if you need some ideas.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

i am able to allow the user to sort the columns of my datagrid, but only in
ascending order. is there a way to allow sorting in descending order?
thanks
in advance.

private void Page_Load(objec t sender, System.EventArg s e)
{

string sTODS = "Select * From TaskOrder";
SqlConnection sqlConn = new SqlConnection(c onnStr);
SqlCommand sqlCMD = new SqlCommand(sTOD S);
sqlCMD.Connecti on = sqlConn;
sqlConn.Open();
SqlDataAdapter adapter = new SqlDataAdapter( sqlCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
dgSearchResults .DataSource = ds.Tables[0];
int tableRowCount = ds.Tables[0].Rows.Count;
if (tableRowCount != 0)
{
DataView dv = new DataView();
dv=ds.Tables[0].DefaultView;
Page.Session.Ad d("DataViewOrig inal",dv);
dgSearchResults .DataSource=dv;
dgSearchResults .DataBind();
dgSearchResults .Visible = true;
}
else
{
dgSearchResults .Visible = false;
}
}

private void dgSearchResults _SortCommand(ob ject source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
if(Page.Session["DataViewOrigin al"]!=null)
{
DataView dv=(DataView) Page.Session["DataViewOrigin al"];
dv.Sort=e.SortE xpression;
dgSearchResults .DataSource=dv; //assign the source
dgSearchResults .DataBind();
}
}

[Ignacio Machin \( .NET/ C# MVP \)]

hi

you need only one.

or two at the most, one to decide which column and the other to decide
asc/desc if in a postback the column var is the same you change the asc/desc
if not change the column and do not change the asc/desc

is it clear now?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:85******** *************** ***********@mic rosoft.com...

there are 8 columns (all sortable). i'm not sure using 8 session variables
to
store everything is the way to go.

"Ignacio Machin ( .NET/ C# MVP )" wrote:

hi

I don;t know how you are declaring the datagrid itself, but all you
have
to do is add an ASC or DESC to the SortExpression.

IIRC the SortCommand of the datagrid does not allow to especify it, so
you
may will need to find another approach or a work around. like keeping in
session the last kind of sorting you did and just do the opposite.

let me know if you need some ideas.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

>i am able to allow the user to sort the columns of my datagrid, but only
>in
> ascending order. is there a way to allow sorting in descending order?
> thanks
> in advance.
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
>
> string sTODS = "Select * From TaskOrder";
> SqlConnection sqlConn = new SqlConnection(c onnStr);
> SqlCommand sqlCMD = new SqlCommand(sTOD S);
> sqlCMD.Connecti on = sqlConn;
> sqlConn.Open();
> SqlDataAdapter adapter = new SqlDataAdapter( sqlCMD);
> DataSet ds = new DataSet();
> adapter.Fill(ds );
> dgSearchResults .DataSource = ds.Tables[0];
> int tableRowCount = ds.Tables[0].Rows.Count;
> if (tableRowCount != 0)
> {
> DataView dv = new DataView();
> dv=ds.Tables[0].DefaultView;
> Page.Session.Ad d("DataViewOrig inal",dv);
> dgSearchResults .DataSource=dv;
> dgSearchResults .DataBind();
> dgSearchResults .Visible = true;
> }
> else
> {
> dgSearchResults .Visible = false;
> }
> }
>
> private void dgSearchResults _SortCommand(ob ject source,
> System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
> {
> if(Page.Session["DataViewOrigin al"]!=null)
> {
> DataView dv=(DataView) Page.Session["DataViewOrigin al"];
> dv.Sort=e.SortE xpression;
> dgSearchResults .DataSource=dv; //assign the source
> dgSearchResults .DataBind();
> }
> }
>

[Newbie]

i already fixed the problem - thanks

"Ignacio Machin ( .NET/ C# MVP )" wrote:

hi

I don;t know how you are declaring the datagrid itself, but all you have
to do is add an ASC or DESC to the SortExpression.

IIRC the SortCommand of the datagrid does not allow to especify it, so you
may will need to find another approach or a work around. like keeping in
session the last kind of sorting you did and just do the opposite.

let me know if you need some ideas.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

i am able to allow the user to sort the columns of my datagrid, but only in
ascending order. is there a way to allow sorting in descending order?
thanks
in advance.

private void Page_Load(objec t sender, System.EventArg s e)
{

string sTODS = "Select * From TaskOrder";
SqlConnection sqlConn = new SqlConnection(c onnStr);
SqlCommand sqlCMD = new SqlCommand(sTOD S);
sqlCMD.Connecti on = sqlConn;
sqlConn.Open();
SqlDataAdapter adapter = new SqlDataAdapter( sqlCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
dgSearchResults .DataSource = ds.Tables[0];
int tableRowCount = ds.Tables[0].Rows.Count;
if (tableRowCount != 0)
{
DataView dv = new DataView();
dv=ds.Tables[0].DefaultView;
Page.Session.Ad d("DataViewOrig inal",dv);
dgSearchResults .DataSource=dv;
dgSearchResults .DataBind();
dgSearchResults .Visible = true;
}
else
{
dgSearchResults .Visible = false;
}
}

private void dgSearchResults _SortCommand(ob ject source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
if(Page.Session["DataViewOrigin al"]!=null)
{
DataView dv=(DataView) Page.Session["DataViewOrigin al"];
dv.Sort=e.SortE xpression;
dgSearchResults .DataSource=dv; //assign the source
dgSearchResults .DataBind();
}
}