Member Avatar for shailaja mohite

Hi,

I am create one application in asp.net. I have to use datagrid view in this application. I want to sort Gender. I am use the template field in datagrid view.

<asp:LinkButton ID="LnkBtnGender" runat="server" CommandName="Sort" CommandArgument="Gender">Gender</asp:LinkButton>

plj help me..

  • 2 Contributors
  • 2 Replies
  • 123 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by shailaja mohite

Dani AI

Generated

was right to point to the GridView sorting event. The symptom in ’s follow‑up (strings sort correctly, RollNo sorts like text) comes from the underlying column type: DataView/GridView sorts numerically only when the DataColumn is numeric. If RollNo is coming back as varchar/text, the sort is lexical ("1,10,2...").

A few safe fixes (pick one that fits the data source):

  • Fix in the database (best). Return RollNo as an integer from the query or cast it:

    SELECT CAST(RollNo AS INT) AS RollNoInt, ...

    Bind or set SortExpression to the numeric column so built‑in sorting is numeric.

  • Convert in memory: add a typed int column to the DataTable and populate it, then sort on that column. Do this immediately after getting ds.Tables[0], before applying RowFilter/Sort:

    DataTable dt = ds.Tables[0];

if (!dt.Columns.Contains("RollNoInt"))
{
    dt.Columns.Add("RollNoInt", typeof(int));
    foreach (DataRow r in dt.Rows)
    {
        int n;
        if (int.TryParse(Convert.ToString(r["RollNo"]), out n))
            r["RollNoInt"] = n;
        else
            r["RollNoInt"] = DBNull.Value;
    }
}

DataView dv = new DataView(dt);
dv.Sort = "RollNoInt " + sortDirection; // "ASC" or "DESC"

  • LINQ approach: order the rows numerically and rebind to a DataTable (handle empty sequences before CopyToDataTable()).

Also, for Gender in a TemplateField prefer setting SortExpression="Gender" on the TemplateField header so GridView’s built‑in sorting works without manual CommandArgument plumbing. If RollNo may contain non‑numeric values or leading zeros that must be preserved, keep the original string column for display and use the numeric column only for sorting. Ensure any ViewState sort string refers to the numeric column name when sorting RollNo.

Recommended Answers

All 2 Replies

Member Avatar for kvprajapati

Handle the Sorting[/b[ event of GridView.

Member Avatar for shailaja mohite 
protected void grdStudentInfo_Sorting(object sender, GridViewSortEventArgs e)
    {
      
     
        string sortExpression = e.SortExpression;

        if (GridViewSortDirection == SortDirection.Ascending)
        {

            GridViewSortDirection = SortDirection.Descending;

            string DESCENDING = "DESC"; 

            SortGridView(sortExpression, DESCENDING);

        }

        else
        {

            GridViewSortDirection = SortDirection.Ascending;

            string ASCENDING = "ASC"; 

            SortGridView(sortExpression, ASCENDING);

        }

       

    }

    private void SortGridView(string sortExpression, string direction)
    {
         ViewState["sortExpression"] = sortExpression + " " + direction;
         FillGrid();

    }

protected void grdStudentInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        { 
            grdStudentInfo.PageIndex = e.NewPageIndex;
            FillGrid();
        }
        catch (Exception) { }

 public void FillGrid()
    {
        try
        {
            DataSet ds = new DataSet();
            ds = BStudentInfo.GetStudentInfo(CourseClassId,"" ,"" , InstituteId,strType);//txtRegNo.Text txtStudentName.Text
            BindData(ds);
        }
        catch (Exception)
        { }
    }
    private void BindData(DataSet ds)
    {
        try
        {
            DataView dv;

            if (ds.Tables[0].Rows.Count > 0)
            {
               if (ViewState["sortExpression"] != null)
                {
                    dv = new DataView(ds.Tables[0]);
                }
                else
                {
                    dv = ds.Tables[0].DefaultView;
                }
               
                grdStudentInfo.DataSourceID = "";
                try
                { 

                    if (strSearchCri != "")
                    {
                        dv.RowFilter = "RegNo like '%" + strSearchCri + "%' or AdmissionDates like '%" + strSearchCri + "%' or StudentName like'%" + strSearchCri + "%' or RollNo like '%" + strSearchCri + "%' or Gender like '%" + strSearchCri + "%' or ReligionName like '%" + strSearchCri + "%' or CasteName like '%" + strSearchCri + "%' or CategoryName like '%" + strSearchCri + "%' or PermanentAdd like '%" + strSearchCri + "%' or LocalAdd like '%" + strSearchCri + "%' or MothersName like '%" + strSearchCri + "%' or PlaceOfBirth like '%" + strSearchCri + "%' or LandLineNo like '%" + strSearchCri + "%' or MobileNo like '%" + strSearchCri + "%' or EmergerencyContactName like '%" + strSearchCri + "%' or EmergencyPhoneNo like '%" + strSearchCri + "%' or FathersCellNo like '%" + strSearchCri + "%' or FathersWorkPhoneNo like '%" + strSearchCri + "%' or FathersEmail like '%" + strSearchCri + "%' or MothersCellNo like '%" + strSearchCri + "%' or MothersWorkPhoneNo like '%" + strSearchCri + "%' or PreviousSchool like '%" + strSearchCri + "%' or ReasonForLeavingPreviousSchool like '%" + strSearchCri + "%' or BloodGroup like '%" + strSearchCri + "%' or StudentEmail like '%" + strSearchCri + "%' or LibraryCategory like '%" + strSearchCri + "%' or ICardNo like '%" + strSearchCri + "%' ";
                        
                        if (strHeaderRegNo != "" || strHeaderAddDate != "" || strHeaderStudentName != "" || strHeaderRollNo != "" || strHeaderGender != "" || strHeaderReligion != "" || strHeaderCaste != "" || strHeaderCategory != "" || strHeaderAddress != "")
                        {
                            dv.RowFilter = "RegNo like '%" + strHeaderRegNo + "%' and AdmissionDates like '%" + strHeaderAddDate + "%' and StudentName like'%" + strHeaderStudentName + "%' and RollNo like '%" + strHeaderRollNo + "%' and Gender like '%" + strHeaderGender + "%' and ReligionName like '%" + strHeaderReligion + "%' and CasteName like '%" + strHeaderCaste + "%' and CategoryName like '%" + strHeaderCategory + "%' and PermanentAdd like '%" + strHeaderAddress + "%'";
                        }
                    }
                    else
                    {
                        if (strHeaderRegNo != "" || strHeaderAddDate != "" || strHeaderStudentName != "" || strHeaderRollNo != "" || strHeaderGender != "" || strHeaderReligion != "" || strHeaderCaste != "" || strHeaderCategory != "" || strHeaderAddress!="")
                        {
                            dv.RowFilter = "RegNo like '%" + strHeaderRegNo + "%' and AdmissionDates like '%" + strHeaderAddDate + "%' and StudentName like'%" + strHeaderStudentName + "%' and RollNo like '%" + strHeaderRollNo + "%' and Gender like '%" + strHeaderGender + "%' and ReligionName like '%" + strHeaderReligion + "%' and CasteName like '%" + strHeaderCaste + "%' and CategoryName like '%" + strHeaderCategory + "%' and PermanentAdd like '%" + strHeaderAddress + "%'";
                        }
                    }
                }
                catch (Exception) { }

                if (ViewState["sortExpression"] != null)
                {                   
                    dv = new DataView(ds.Tables[0]);
                    dv.Sort =(string)ViewState["sortExpression"];
                }
                

                if(dv.Count<=0)
                {
                    EmptyGrid();
                }
                else
                {
                    grdStudentInfo.DataSource = dv;
                    grdStudentInfo.DataBind();
                }

                txtSearchCriteria.Text = strSearchCri;

                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderStudentName")).Text = strHeaderStudentName;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderRegNo")).Text = strHeaderRegNo;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderAddDate")).Text = strHeaderAddDate;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderRollNo")).Text = strHeaderRollNo;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderGender")).Text = strHeaderGender;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderReligion")).Text = strHeaderReligion;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderCaste")).Text = strHeaderCaste;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtHeaderCategory")).Text = strHeaderCategory;
                ((TextBox)grdStudentInfo.HeaderRow.FindControl("txtPermanentAdd")).Text = strHeaderAddress;


               
              

                lblRecordCount.Text = dv.Count.ToString();

                if (dv.Count > 0)
                {
                    DisplaySerialNumber();
                }
               
                try
                {
                    displayTotalRecPerPage();
                }
                catch (Exception)
                {
                }

            }
            else
            {
                EmptyGrid();
            }
        }
        catch (Exception) { }

Hi,
In my web application sort string data correctly.but rollno is integer value they do not sort correctly.plz how to sort integer values in datagrid view in Asp.Net
plj help me...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.