CODEWITHSUNDEEP
c#asp.netdatabase
chetan singhal
chetan singhal

Reputation: 948

How sort data taking from database in C#

There is state table that have statename and circode but they are not sorted in table. I use OrderByAsc("StateName") where StateName is a column name of state table. How I get sorted state in dropdownlist. I use subsonic to fetch data from database.

StateCollection stc = (new 
StateController()).getInstance().WFetchAll(true);


    ddlState.Items.Clear();
    if(addAllStates)
        ddlState.Items.Add(new ListItem("All States", "0"));

    //ddlState.DataSource = State.FetchAll();
    //ddlState.DataTextField = State.Columns.StateName;
    //ddlState.DataValueField = State.Columns.CircleCode;
    //ddlState.DataBind();
    stc = stc.OrderByAsc("CircleCode");
    stc.SaveAll();
    foreach (State st in stc)
    {
        ddlState.Items.Add(new ListItem(st.CircleCode + "-" + st.StateName, st.CircleCode));
    }

Upvotes: 0

Views: 1525

Answers (1)

Bala R
Bala R

Reputation: 108957

Try

foreach (State st in stc.OrderBy(s => s.StateName))
{
    ddlState.Items.Add(new ListItem(st.CircleCode + "-" + st.StateName, st.CircleCode));
}

Upvotes: 2

Related Questions