i am trying to get large data from server that's why i am converting the dataset to datatable and assign it into linq query it's working fine but when i try to apply where condition it getting the errors how can i apply to filered the conditions.
here's is my code
[WebMethod]
public static List<GridDetails> BindGridDetails(string StartDate, string EndDate, int CatID, string Customer, string Description, int Status, string ddlstatus)
{
List<GridDetails> results = new List<GridDetails>();
DataSet ds = new DataSet();
GetData gd=new GetData();
ds = gd.GetGridDetails(StartDate, EndDate);
DataTable dt = ds.Tables[0];
var query=from pending in dt.AsEnumerable()
select new
{
ID = pending[0],
SubmittedDate = pending[1],
SubCatID = pending[2],
...
Go to the complete details ...