Hi,

I have a gridview which I want to sort it. But I have a problem with the code. You have any idea what it's wrong?



 <asp:GridView ID="gvUserList" ForeColor="red" AutoGenerateColumns="false" runat="server" OnRowCommand="gvUserList_RowCommand" OnRowDataBound="gvUserList_RowDataBound" AllowPaging="true" AllowSorting="true" OnPageIndexChanging="gvUserList_PageIndexChanging" OnSorting="gvUserList_PageSorting" >
            <Columns>
            <asp:BoundField DataField="UserID" Visible="false" />

            <asp:TemplateField >
                 <HeaderTemplate >
                     <asp:LinkButton ID="lblUserName" runat="server">UserName</asp:LinkButton>
                 </HeaderTemplate>
                 <ItemTemplate>
                      <asp:LinkButton ID="lnkUserName" runat="server" CommandName="EditUser" ForeColor="red" Text='<%# Bind("UserName") %>'> </asp:LinkButton>
                 </ItemTemplate>
            </asp:TemplateField>

            <asp:BoundField DataField="FirstName" HeaderText="First Name" />
            <asp:BoundField DataField="LastName" HeaderText="Last Name" />
            <asp:BoundField DataField="Age" HeaderText="Age" />
            <asp:BoundField DataField="Email" HeaderText="Email" />
            <asp:BoundField DataField="Inactive" HeaderText="Status" Visible="false"/>

            <asp:TemplateField >
                 <ItemTemplate>
                        <asp:ImageButton ID="imgbtnSetInactiveUser" runat="server" ImageUrl="~/Images/inactive.jpg" CommandName="SetUser" />
                 </ItemTemplate>
            </asp:TemplateField>
            </Columns>

            </asp:GridView>


 protected void gvUserList_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {

            gvUserList.PageIndex = e.NewPageIndex;
            gvUserList.DataBind();


        }



        protected void gvUserList_PageSorting(object sender, GridViewSortEventArgs e)
        {

            DataTable objDT = gvUserList.DataSource as DataTable;

            if (objDT != null)
            {

                DataView objDV = new DataView(objDT);
                objDV.Sort = e.SortExpression + " " + SqlSortDirection(e.SortDirection);

                gvUserList.DataSource = objDV;
                gvUserList.DataBind();


            }


        }


        private string SqlSortDirection(SortDirection sortDirection)
        {

            string newSortDirection = string.Empty;

            if (sortDirection == SortDirection.Ascending)
            {
                newSortDirection = "ASC";
            }

            else if ( sortDirection == SortDirection.Descending)
            {
                newSortDirection = "DESC";
            }


            return newSortDirection;

        }









Thank you

__________________
Thank you

You don't actually say what the problem is?

/- Sam Judson : Wrox Technical Editor -/

The problem is that the link button appears in the gridview list, but when I click on it, nothing happens .(it should sort my column, but something it's wrong.)

Even If I add "Sort Expression" to <asp:BoundField> tag, sorting is not working.


Thank you

This line here assumes that the DataSource is a DataTable - yet in the very next bit of code you assign a DataView to DataSource. I suspect this will be where your problem lies.

/- Sam Judson : Wrox Technical Editor -/

I need that DataView for sorting. DataView is view of a DataTable , and I use it for sorting, searching, editing.

I cannot use Sort property directly with DataTable.

Anyway , is a DataView of a DataTable : DataView objDV = new DataView(objDT);

I think another line is my problem.

Thank you

I realise you have to use DataView, but if you assign a DataView to the DataSource of your GridView then in the above line objDT will be null.

/- Sam Judson : Wrox Technical Editor -/

Sam, can you give me one suggestion , please ?



Thank you

I've already highlighted the area I think you should be investigating. I really don't know what else to say.

/- Sam Judson : Wrox Technical Editor -/