DataGrid and Simple Sorting

[thejackofall]

Hi.

I am having a problem doing a simple sorting. Would someone be cool enough
to take a look and advise? It doesn't sort.

+++++++++++++++ +++++++++++++++ +++++++++++++++ ++++++++++++++

using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Configur ation;
using System.Data.Sql Client;

using Microsoft.Appli cationBlocks.Da ta;

namespace Wells.Complianc e.UI.SAR
{
/// <summary>
/// Summary description for index.
/// </summary>
public class index : System.Web.UI.P age
{
protected ComponentArt.We b.UI.Menu Menu1;
protected System.Web.UI.W ebControls.Data Grid DataGrid1;
protected System.Web.UI.H tmlControls.Htm lForm Form1;

private string m_sSortColumn = "";
private string m_sSortOrder = "";

private void Page_Load(objec t sender, System.EventArg s e)
{
//if (!IsPostBack)
//{
//if (m_sSortColumn == "")
//{
Session["SortColumn "] = "InsertDate ";
Session["SortOrder"] = " asc";
//}

BindGrid();
//DataGrid1.DataS ource = GetDataSource() ;
//DataGrid1.DataB ind();
//}
}

#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeCompo nent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.DataGrid1. SortCommand += new
System.Web.UI.W ebControls.Data GridSortCommand EventHandler(th is.SortData);
this.DataGrid1. SelectedIndexCh anged += new
System.EventHan dler(this.DataG rid1_SelectedIn dexChanged);
this.Load += new System.EventHan dler(this.Page_ Load);

}
#endregion

private void DataGrid1_Selec tedIndexChanged (object sender,
System.EventArg s e)
{

}

private ICollection GetDataSource()
{
string sConn = ConfigurationSe ttings.AppSetti ngs["ConnectStr ing"];
DataTable dt = new DataTable();
DataRow dr;

dt.Columns.Add( new DataColumn("Pac kageID", typeof(string)) );
dt.Columns.Add( new DataColumn("Sta tus", typeof(string)) );
dt.Columns.Add( new DataColumn("Ins ertDate", typeof(string)) );

SqlDataReader sdr = SqlHelper.Execu teReader(sConn, "spGetUnusualPa ckage");

while (sdr.Read())
{
dr = dt.NewRow();

dr[0] = sdr["PackageID"].ToString();
dr[1] = sdr["Status"].ToString();
dr[2] = sdr["InsertDate "].ToString();

dt.Rows.Add(dr) ;
}

// To persist the data source between posts to the server,
// store it in session state.
Session["Source"] = dt;
//Session["SortOrder"] = " asc";

DataView dv = new DataView(dt);
dv.Sort = Session["SortColumn "].ToString() +
Session["SortOrder"].ToString();

return dv;
}

private void SortData(Object sender, DataGridSortCom mandEventArgs e)
{
Session["SortColumn "] = (string) e.SortExpressio n;

if (Session["SortOrder"].ToString() == " desc")
Session["SortOrder"] = " asc";
else
Session["SortOrder"] = " desc";

BindGrid();

// Retrieve the data source from session state.
//DataTable dt = (DataTable) Session["Source"];

// Create a DataView from the DataTable.
//DataView dv = new DataView(dt);

// The DataView provides an easy way to sort. Simply set the
// Sort property with the name of the field to sort by.

//dv.Sort = e.SortExpressio n; //+ m_sSortOrder;

// Re-bind the data source and specify that it should be sorted
// by the field specified in the SortExpression property.
//DataGrid1.DataS ource = dv;
//DataGrid1.DataB ind();
}

private void BindGrid()
{
DataGrid1.DataS ource = GetDataSource() ;
DataGrid1.DataB ind();
}
}
}

--
Be Cool!

[thejackofall]

I don't know if this would help, but whenever I put the cursor on the column
haeder, it displays the following message:

javascript: __doPostBack(Da taGrid1$_ctl14_ ctl0', '')

Any help is appreciated.

"thejackofa ll" wrote:

Hi.

I am having a problem doing a simple sorting. Would someone be cool enough
to take a look and advise? It doesn't sort.

+++++++++++++++ +++++++++++++++ +++++++++++++++ ++++++++++++++

using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Configur ation;
using System.Data.Sql Client;

using Microsoft.Appli cationBlocks.Da ta;

namespace Wells.Complianc e.UI.SAR
{
/// <summary>
/// Summary description for index.
/// </summary>
public class index : System.Web.UI.P age
{
protected ComponentArt.We b.UI.Menu Menu1;
protected System.Web.UI.W ebControls.Data Grid DataGrid1;
protected System.Web.UI.H tmlControls.Htm lForm Form1;

private string m_sSortColumn = "";
private string m_sSortOrder = "";

private void Page_Load(objec t sender, System.EventArg s e)
{
//if (!IsPostBack)
//{
//if (m_sSortColumn == "")
//{
Session["SortColumn "] = "InsertDate ";
Session["SortOrder"] = " asc";
//}

BindGrid();
//DataGrid1.DataS ource = GetDataSource() ;
//DataGrid1.DataB ind();
//}
}

#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeCompo nent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.DataGrid1. SortCommand += new
System.Web.UI.W ebControls.Data GridSortCommand EventHandler(th is.SortData);
this.DataGrid1. SelectedIndexCh anged += new
System.EventHan dler(this.DataG rid1_SelectedIn dexChanged);
this.Load += new System.EventHan dler(this.Page_ Load);

}
#endregion

private void DataGrid1_Selec tedIndexChanged (object sender,
System.EventArg s e)
{

}

private ICollection GetDataSource()
{
string sConn = ConfigurationSe ttings.AppSetti ngs["ConnectStr ing"];
DataTable dt = new DataTable();
DataRow dr;

dt.Columns.Add( new DataColumn("Pac kageID", typeof(string)) );
dt.Columns.Add( new DataColumn("Sta tus", typeof(string)) );
dt.Columns.Add( new DataColumn("Ins ertDate", typeof(string)) );

SqlDataReader sdr = SqlHelper.Execu teReader(sConn, "spGetUnusualPa ckage");

while (sdr.Read())
{
dr = dt.NewRow();

dr[0] = sdr["PackageID"].ToString();
dr[1] = sdr["Status"].ToString();
dr[2] = sdr["InsertDate "].ToString();

dt.Rows.Add(dr) ;
}

// To persist the data source between posts to the server,
// store it in session state.
Session["Source"] = dt;
//Session["SortOrder"] = " asc";

DataView dv = new DataView(dt);
dv.Sort = Session["SortColumn "].ToString() +
Session["SortOrder"].ToString();

return dv;
}

private void SortData(Object sender, DataGridSortCom mandEventArgs e)
{
Session["SortColumn "] = (string) e.SortExpressio n;

if (Session["SortOrder"].ToString() == " desc")
Session["SortOrder"] = " asc";
else
Session["SortOrder"] = " desc";

BindGrid();

// Retrieve the data source from session state.
//DataTable dt = (DataTable) Session["Source"];

// Create a DataView from the DataTable.
//DataView dv = new DataView(dt);

// The DataView provides an easy way to sort. Simply set the
// Sort property with the name of the field to sort by.

//dv.Sort = e.SortExpressio n; //+ m_sSortOrder;

// Re-bind the data source and specify that it should be sorted
// by the field specified in the SortExpression property.
//DataGrid1.DataS ource = dv;
//DataGrid1.DataB ind();
}

private void BindGrid()
{
DataGrid1.DataS ource = GetDataSource() ;
DataGrid1.DataB ind();
}
}
}

--
Be Cool!