click on column head to sort, DataGrid is gone if adding columns programatically

**adamshao** · November 26th, 2002, 03:10 PM

I add a column programatically, and need to enable sorting. If I click the sorting head, the datagrid will disapper. However, if I hard code the column adding in the ASPX page, the datagrid shows correctly. Any suggestion to solve this problem?

<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="WebApplication10.WebForm1" %>
<HTML>
<body>
<form id="Form1" runat="server">
<h3>DataGrid Sorting Example</h3>
<asp

ataGrid id="ItemsGrid" runat="server" BorderColor="black" BorderWidth="1" CellPadding="3" AllowSorting="true" OnSortCommand="Sort_Grid" HeaderStyle-BackColor="#00aaaa" AutoGenerateColumns="false">

</asp

ataGrid>

</form>
</body>
</HTML>

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebApplication10
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid ItemsGrid;
string SortExpression;

ICollection CreateDataSource()
{
DataTable dt = new DataTable();
DataRow dr;
Random Rand_Num = new Random();

dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
dt.Columns.Add(new DataColumn("CurrencyValue", typeof(double)));

for (int i = 15; i >0; i--)
{
dr = dt.NewRow();

dr[0] = i;
dr[1] = "Item " + i.ToString();
dr[2] = 1.23 * Rand_Num.Next(1, 15);

dt.Rows.Add(dr);
}

DataView dv = new DataView(dt);
dv.Sort=SortExpression;
return dv;
}

void Page_Load(Object sender, EventArgs e)
{

if (!IsPostBack)
{

if (SortExpression == "")
SortExpression = "IntegerValue";
ItemsGrid.DataSource = CreateDataSource();

InitializeBoundColumns();
ItemsGrid.DataBind();
}

}

private void InitializeBoundColumns()
{
ItemsGrid.AutoGenerateColumns = false;
ItemsGrid.AllowSorting = true;

HyperLinkColumn urlCol = new HyperLinkColumn();

urlCol.HeaderText="IntegerValue";
urlCol.DataNavigateUrlField="IntegerValue";
urlCol.DataNavigateUrlFormatString="detailspage.aspx?id={0}";
urlCol.DataTextField="IntegerValue";
urlCol.DataTextFormatString="{0:c}";
urlCol.SortExpression = "IntegerValue";
urlCol.Target="_new";
ItemsGrid.Columns.Add(urlCol);
}

public void Sort_Grid(Object sender, DataGridSortCommandEventArgs e)
{
SortExpression = e.SortExpression.ToString();
ItemsGrid.DataSource = CreateDataSource();
ItemsGrid.DataBind();
}

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

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}

**hhieu** · November 26th, 2002, 09:01 PM

You can not change in program, but you can change in visual mode. You missed some tags that require for the grid.

Thread: click on column head to sort, DataGrid is gone if adding columns programatically

Thread Tools

Display

click on column head to sort, DataGrid is gone if adding columns programatically

Posting Permissions