Orderby query using oledb

Ayush Patil

Here my query

var ddlPCName = (from r in CAR.AsEnumerable() select r["Name"]).Distinct().ToList();

i am trying to apply orderby but its going to failed.

please help me to solve this issue.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Below sample DataTable given the result. In LINQ you want to use r.Field("Name")

DataTable CAR = new DataTable();
CAR.Columns.Add(new DataColumn("Id", typeof(System.Int32)));
CAR.Columns.Add(new DataColumn("Name", typeof(System.String)));
CAR.Columns.Add(new DataColumn("Model", typeof(System.String)));
DataRow row1 = CAR.NewRow();
row1["Id"] = 100;
row1["Name"] = "XX";
row1["Model"] = "M1";
CAR.Rows.Add(row1);
DataRow row2 = CAR.NewRow();
row2["Id"] = 200;
row2["Name"] = "AA";
row1["Model"] = "M2";
CAR.Rows.Add(row2);
var sortList = (from r in CAR.AsEnumerable() orderby r.Field("Name") select r).ToList();
foreach(DataRow row in sortList)
{
string nams = row.Field("Name");
}
Ayush Patil8y ago
here i am using excel sheet and convert into datatable.

DataTable CAR = ExcelData.Tables[1];

var ddlPCName = (from r in CAR.AsEnumerable() select r["Name"]).Distinct().ToList();

i need to set ddlPCName through OrderBy.
Jaish Mathews8y ago
I am not sure about type of your collection named 'CAR'. Also this is related to LINQ, not OLEDB. Below query worked for me, if collection type is List.
List CAR = new List();
CAR.AddRange(new List { new Car { Id = 100, Model = "M1", Name = "X" } , new Car { Id = 200, Model = "M2", Name = "A" } });
var sort = (from s in CAR orderby s.Name select s); );