Sorting dataset in asp.net c#

Question

I'm trying to sort the data,however the names do not get sorted when I jump from one page to another.

return new dao_StudentGroupStudents().GetNewStudentbyGroup(bureauId, search, groupId, currentPage, pageSize, out totalCount);

    /// <summary>
    /// Get All the students from that Bureau.
    /// </summary>

    public DataSet GetAllStudentGroupByBureau(int? GroupId, int? BureauID)
    {
        DataSet ds = new dao_StudentGroup().GetDataSet(null, null, BureauID);
        ds.Tables[0].DefaultView.Sort = "grouptitle asc";
        return ds;
    }

I'm typing this in and now I get Cannot find column columnName.

public DataSet GetAllStudentGroupByBureau(int? GroupId, int? BureauID) { DataSet ds = new dao_StudentGroup().GetDataSet(null, null, BureauID);

ds.Tables[0].DefaultView.Sort = "columnName ASC";

DataTable dt = ds.Tables[0].DefaultView.ToTable();

return ds;

}

Is there a question here?

iGanja
– iGanja

2013-03-25 15:32:31 +00:00
Commented Mar 25, 2013 at 15:32 — iGanja
– iGanja, Commented Mar 25, 2013 at 15:32
So then its sorted correctly on the first page?

jiiri
– jiiri

2013-03-25 15:36:25 +00:00
Commented Mar 25, 2013 at 15:36 — jiiri
– jiiri, Commented Mar 25, 2013 at 15:36

palaѕн · Accepted Answer · 2013-03-28 14:14:36Z

5

Try this:

DataSet ds = new dao_StudentGroup().GetDataSet(null, null, BureauID);
ds.Tables[0].DefaultView.Sort = "grouptitle asc";
ds.Tables[0] = ds.Tables[0].DefaultView.ToTable();
return ds;

UPDATE

You can simply do this then:

public DataSet GetAllStudentGroupByBureau(int ? GroupId, int ? BureauID) 
{
    DataSet ds = new dao_StudentGroup().GetDataSet(null, null, BureauID);

    ds.Tables[0].DefaultView.Sort = "grouptitle asc";        
    DataTable dt = ds.Tables[0].DefaultView.ToTable();
    ds.Tables[0].Rows.Clear();
    foreach (DataRow row in dt.Rows)
       ds.Tables[0].Rows.Add(row.ItemArray);

    return ds;
}

edited Mar 28, 2013 at 14:14

answered Mar 25, 2013 at 15:34

palaѕн

74.2k17 gold badges123 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user2208126 Over a year ago

ds.Tables[0] produces an error. proptery or indexes system.Datadatatablescollection.this[int] Cannot be assigned to is is read only

user2208126 Over a year ago

I'm getting this error now Error 6 'BusinessObjects.StudentGroupManager' does not implement interface member 'BusinessObjects.Contracts.IStudentGroupManager.GetAllStudentGroupByBureau(int?, int?)'. 'BusinessObjects.StudentGroupManager.GetAllStudentGroupByBureau(int?, int?)' cannot implement 'BusinessObjects.Contracts.IStudentGroupManager.GetAllStudentGroupByBureau(int?, int?)' because it does not have the matching return type of 'System.Data.DataSet'. C:\workspace\DOP.IT.Training\Development\MS\BusinessObjects\StudentGroupManager.cs 11 18 BusinessObjects

user2208126 Over a year ago

The second "=" in the DataTable dt is giving me an invalid expression term and the ds. is giving me an "; expected"

palaѕн Over a year ago

@user2208126: Sorry, that was a typing mistake. I have updated the code. Try it once!

Umesh · Accepted Answer · 2013-03-26 06:47:29Z

2

You can try the following. Remember, you can't assign value to ds.Table[] back. Hence you need to create a new datatable and add it to either new or existing dataset

    ds.Tables[0].DefaultView.Sort = "columnName ASC";

    DataTable dt = ds.Tables[0].DefaultView.ToTable();

answered Mar 26, 2013 at 6:47

Umesh

2,74021 silver badges24 bronze badges

5 Comments

user2208126 Over a year ago

= is giving me an invalid expression term

user2208126 Over a year ago

I'm getting this error now Error 6 'BusinessObjects.StudentGroupManager' does not implement interface member 'BusinessObjects.Contracts.IStudentGroupManager.GetAllStudentGroupByBureau(int?, int?)'. 'BusinessObjects.StudentGroupManager.GetAllStudentGroupByBureau(int?, int?)' cannot implement 'BusinessObjects.Contracts.IStudentGroupManager.GetAllStudentGroupByBureau(int?, int?)' because it does not have the matching return type of 'System.Data.DataSet'. C:\workspace\DOP.IT.Training\Development\MS\BusinessObjects\StudentGroupManager.‌cs 11 18 BusinessObjects

Umesh Over a year ago

I was able to compile the above code without any error. By looking at your code above, it seems that there is something else which is causing the issue.

user2208126 Over a year ago

I'm putting this in and I get Cannot find column columnName. public DataSet GetAllStudentGroupByBureau(int? GroupId, int? BureauID) { DataSet ds = new dao_StudentGroup().GetDataSet(null, null, BureauID); ds.Tables[0].DefaultView.Sort = "columnName ASC"; DataTable dt = ds.Tables[0].DefaultView.ToTable(); return ds; }

Umesh Over a year ago

Obviously columnName means the name of the field you want to sort on. You need to change it to original column name, it was just for reference/example only

jiiri · Accepted Answer · 2013-03-25 15:51:42Z

0

You could try this:

    //convert DataSet table to DataView  
    DataView dv = ds.Tables[0].DefaultView; 

    //apply the sort   
    dv.Sort = "grouptitle ASC"; 

    //save back into our dataset  
    ds.Tables[0] = dv.ToTable();

answered Mar 25, 2013 at 15:51

jiiri

3301 silver badge12 bronze badges

1 Comment

user2208126 Over a year ago

ds.Tables[0] produces an error. proptery or indexes system.Datadatatablescollection.this[int] Cannot be assigned to is is read only

vishal sonekar · Accepted Answer · 2013-07-15 06:12:48Z

0

DataView dv = ds.Tables[0].DefaultView;

dv.Sort = "grouptitle ASC"; 

ds = dv.ToTable();

try these

default it comes in ds.table[0] no need to menstion it

answered Jul 15, 2013 at 6:12

vishal sonekar

1

Collectives™ on Stack Overflow

Sorting dataset in asp.net c#

4 Answers 4

4 Comments

5 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

5 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related