How to sort a sql query in memory

28 Oct 2011

0 comments

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test35.aspx.cs" Inherits="Test35" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="Beweb" %>

<html>

<head>

</head>

<body>

var sql = new Sql("select * from registration");

var registrations = BewebData.GetDataSet(sql.ToString());

if(registrations.Tables[0].Rows.Count>0)

{

//create new col called sortposn

var datacol = new DataColumn("SortPosn",typeof(int));

registrations.Tables[0].Columns.Add(datacol);

//fill the columns

foreach (DataRow dr in registrations.Tables[0].Rows)

{

if(dr["Status"]+""=="Registered")dr["SortPosn"] = 1;

if(dr["Status"]+""=="Waitlisted")dr["SortPosn"] = 2;

if(dr["Status"]+""=="Cancelled")dr["SortPosn"] = 3;

}

registrations.Tables[0].DefaultView.Sort = "SortPosn asc";

//foreach (var op in registrations)

foreach (DataRowView dr in registrations.Tables[0].DefaultView)

{

//var data = new Models.WhiteLabel();

//data.UpdateFromObject(dr);

<%--blah[<%=data.Status%>]--%>

blah[<%=dr["Status"]%>]

}

</body>

</html>

Csharp and ASP dot net