GridView排序

最新推荐文章于 2013-05-28 17:00:59 发布

转载最新推荐文章于 2013-05-28 17:00:59 发布 · 661 阅读

文章标签：

#asp #server #sorting #html #c# #image

.net 专栏收录该内容

32 篇文章

订阅专栏

<%@ Page language="C#" %>

void CustomersGridView_Sorting(Object sender, GridViewSortEventArgs e)

{

// Cancel the sorting operation if the user attempts

// to sort by address.

if (e.SortExpression == "Address")

{

e.Cancel = true;

Message.Text = "You cannot sort by address.";

SortInformationLabel.Text = "";

}

else

{

Message.Text = "";

}

void CustomersGridView_Sorted(Object sender, EventArgs e)

{

// Display the sort expression and sort direction.

SortInformationLabel.Text = "Sorting by " +

CustomersGridView.SortExpression.ToString() +

" in " + CustomersGridView.SortDirection.ToString() +

" order.";

}

</script>

<html>

<body>

<h3>GridView Sorting Example</h3>

<asp:label id="Message"

forecolor="Red"

runat="server"/>

<br/>

<asp:label id="SortInformationLabel"

forecolor="Navy"

runat="server"/>

<br/>

<asp:gridview id="CustomersGridView"

datasourceid="CustomersSource"

autogeneratecolumns="true"

allowpaging="true"

emptydatatext="No data available."

allowsorting="true"

onsorting="CustomersGridView_Sorting"

onsorted="CustomersGridView_Sorted"

runat="server">

</asp:gridview>

<asp:sqldatasource id="CustomersSource"

selectcommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"

connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>"

runat="server"/>

</form>

</body>

</html>

-------------------------------------------------------------

<%@ Page language="C#" %>

void CustomersGridView_RowCreated(Object sender, GridViewRowEventArgs e)

{

// Use the RowType property to determine whether the

// row being created is the header row.

if (e.Row.RowType == DataControlRowType.Header)

{

// Call the GetSortColumnIndex helper method to determine

// the index of the column being sorted.

int sortColumnIndex = GetSortColumnIndex();

if (sortColumnIndex != -1)

{

// Call the AddSortImage helper method to add

// a sort direction image to the appropriate

// column header.

AddSortImage(sortColumnIndex, e.Row);

}

// This is a helper method used to determine the index of the

// column being sorted. If no column is being sorted, -1 is returned.

int GetSortColumnIndex()

{

// Iterate through the Columns collection to determine the index

// of the column being sorted.

foreach (DataControlField field in CustomersGridView.Columns)

{

if (field.SortExpression == CustomersGridView.SortExpression)

{

return CustomersGridView.Columns.IndexOf(field);

}

return -1;

}

// This is a helper method used to add a sort direction

// image to the header of the column being sorted.

void AddSortImage(int columnIndex, GridViewRow headerRow)

{

// Create the sorting image based on the sort direction.

Image sortImage = new Image();

if (CustomersGridView.SortDirection == SortDirection.Ascending)

{

sortImage.ImageUrl = "~/Images/Ascending.jpg";

sortImage.AlternateText = "Ascending Order";

}

else

{

sortImage.ImageUrl = "~/Images/Descending.jpg";

sortImage.AlternateText = "Descending Order";

}

// Add the image to the appropriate header cell.

headerRow.Cells[columnIndex].Controls.Add(sortImage);

}

</script>

<html>

<body>

<h3>GridView AllowSorting Example</h3>

<asp:gridview id="CustomersGridView"

datasourceid="CustomersSource"

autogeneratecolumns="false"

emptydatatext="No data available."

allowsorting="true"

onrowcreated="CustomersGridView_RowCreated"

runat="server">

<asp:boundfield datafield="CustomerID"

headertext="Customer ID"

headerstyle-wrap="false"

sortexpression="CustomerID"/>

<asp:boundfield datafield="CompanyName"

headertext="CompanyName"

headerstyle-wrap="false"

sortexpression="CompanyName"/>

<asp:boundfield datafield="Address"

headertext="Address"

headerstyle-wrap="false"

sortexpression="Address"/>

<asp:boundfield datafield="City"

headertext="City"

headerstyle-wrap="false"

sortexpression="City"/>

<asp:boundfield datafield="PostalCode"

headertext="Postal Code"

headerstyle-wrap="false"

sortexpression="PostalCode" />

<asp:boundfield datafield="Country"

headertext="Country"

headerstyle-wrap="false"

sortexpression="Country"/>

</columns>

</asp:gridview>

<asp:sqldatasource id="CustomersSource"

selectcommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"

connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>"

runat="server"/>

</form>

</body>

</html>