Wednesday, January 21, 2009

GridView -Grouping















Sample

Normal
Total
Custom Operation : GetMinQuantity
Total and CustomOperation
Non automatic summary
Group
Group (don't hide group column)
Group with Group Summary
Group with Group Summary and General Summary
Suppress group (hide non summarized columns)
Suppress group (don't hide)
Two Groups
Composite group
Not supported: Summary of inner groups





Group by

ShipRegion
ShipName
OrderId





Other options





Code Behind

protected void Page_Load(object sender, EventArgs e)
{
display();
}
private void display()
{
DataTable dt = new DataTable();
DataColumn dc = new DataColumn();
DataRow myDataRow;
dt.Columns.Add("ShipRegion");
dt.Columns.Add("ShipName");
dt.Columns.Add("OrderId");
dt.Columns.Add("ProductName");
dt.Columns.Add("Quantity");
dt.Columns.Add("UnitPrice");
dt.Columns.Add("ItemTotal");
myDataRow = dt.NewRow();
myDataRow["ShipRegion"] = "RJ";
myDataRow["ShipName"] = "Hanari Carnes";
myDataRow["OrderId"] = "10922";
myDataRow["ProductName"] = "Alice Mutton";
myDataRow["Quantity"] = "15";
myDataRow["UnitPrice"] = "39,00";
myDataRow["ItemTotal"] = "585,00";
dt.Rows.Add(myDataRow);
myDataRow = dt.NewRow();
myDataRow["ShipRegion"] = "RJ";
myDataRow["ShipName"] = "Hanari Carnes";
myDataRow["OrderId"] = "10922";
myDataRow["ProductName"] = "Alice Mutton";
myDataRow["Quantity"] = "15";
myDataRow["UnitPrice"] = "39,00";
myDataRow["ItemTotal"] = "5858,00";
dt.Rows.Add(myDataRow);
myDataRow = dt.NewRow();
myDataRow["ShipRegion"] = "RJ";
myDataRow["ShipName"] = "Hanari Carnes";
myDataRow["OrderId"] = "10922";
myDataRow["ProductName"] = "Alice Mutton";
myDataRow["Quantity"] = "15";
myDataRow["UnitPrice"] = "39,00";
myDataRow["ItemTotal"] = "585,00";
dt.Rows.Add(myDataRow);
myDataRow = dt.NewRow();
myDataRow["ShipRegion"] = "sJ";
myDataRow["ShipName"] = "Hanari Carnes";
myDataRow["OrderId"] = "10922";
myDataRow["ProductName"] = "Alice Mutton";
myDataRow["Quantity"] = "15";
myDataRow["UnitPrice"] = "39,00";
myDataRow["ItemTotal"] = "5858,00";
dt.Rows.Add(myDataRow);
GridView1.DataSource = dt;
GridView1.DataBind();

}
protected void GVRowDB(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
switch (rdBtnList.SelectedValue)
{
case "4":
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label titleLabel = (Label)e.Row.FindControl("ShipRegion");
string strval = ((Label)(titleLabel)).Text;
string title = (string)ViewState["title"];
if (title == strval)
{
titleLabel.Visible = false;
titleLabel.Text = string.Empty;
}
else
{
title = strval;
ViewState["title"] = title;
titleLabel.Visible = true;
titleLabel.Text = "
" + title + "
";
}
}
break;
}
}
}