Sorting a ADO.NET Datatable

Question

I have a datatable in C#.

DataTable dtClientMedications = new DataTable();
dtClientMedications.Columns.Add("Id");
dtClientMedications.Columns.Add("MedId");
dtClientMedications.Columns.Add("BrandName");
dtClientMedications.Columns.Add("GenericName");
dtClientMedications.Columns.Add("Type");
dtClientMedications.Columns.Add("Dosage");
dtClientMedications.Columns.Add("Status");
dtClientMedications.Columns.Add("SortOrder");

I want to sort in by the column SortOrder & assign it to a gridview. I used this:

gdvMainList.DataSource = dtClientMedications.DefaultView.Sort[7];//dtClientMedications;
gdvMainList.DataBind();

But it gives index out of bound exception.

It will depend on your datatable column length. How many columns does your datatable contains? — Sai Kalyan Kumar Akshinthala, Sep 06 '11 at 05:34

Meligy · Accepted Answer · 2011-09-06T05:51:38.840

5

You are missing what the Sort property is in fact.

It is the expression that you want to sort. A string value, not index of columns. Your code tries to read the 6th char in an assumed existing sort string, no more!

Use

dtClientMedications.DefaultView.Sort = "SortOrder";

Before data binding.

gdvMainList.DataSource = dtClientMedications.DefaultView; // You may not need to mention view
gdvMainList.DataBind();

.

Documentation: http://msdn.microsoft.com/en-us/library/system.data.dataview.sort.aspx

edited Sep 06 '11 at 05:51

answered Sep 06 '11 at 05:40

Meligy

35,654
11
85
109

okay, can I assign a DataView to Gridview as a datasource? like I do with the datatable. – asma Sep 06 '11 at 05:42
Yes. I think so. I haven't done this in a while but I think assigning either will be similar, since it is a "default" view anyway. See the updated code in the answer. – Meligy Sep 06 '11 at 05:44
Working perfect. Thanx Mohamed Meligy – asma Sep 06 '11 at 05:51

score 1 · Answer 2 · answered Sep 06 '11 at 05:35

1

Sort is string property.

Use,

dtClientMedications.DefaultView.Sort="ID"

answered Sep 06 '11 at 05:35

KV Prajapati

93,659
19
148
186

Doesn't the datasource have to support the Sort method? – McArthey Sep 06 '11 at 05:37
@asma: in answer to your first comment, yes, use `...Sort="SortOrder"` – Josh Darnell Sep 06 '11 at 05:41

score 1 · Answer 3 · answered Sep 06 '11 at 05:36

1

You can sort the columns in the table itself:

dtClientMedications.Columns["SortOrder"].SetOrdinal(0);

answered Sep 06 '11 at 05:36

VoodooChild

9,776
8
66
99

I want to sort all columns in fact the whole datatable by SortOrder. – asma Sep 06 '11 at 05:37

Sorting a ADO.NET Datatable

3 Answers3