Orderby query using oledb

Question

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.

Jaish Mathews · Answer

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 Patil · Answer

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 Mathews · Answer

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); );

Orderby query using oledb

Answers (3)