Hi,

I know...but that does not apply in this case as i am not using standard tables in the database, i am using one stored procedure which returns a result set which i put in a datatable

and which i cache now i want to query that cached datatable using linq query but when i set my gridview datasource to point to the query i get a 

  "The data source does not support server-side data paging" error so i need a way to convert the result which is stored in query back into a datable so that i can then set that to my Gridview and not get that paging error issue..so how do i do that using Linq as i dont see a way of doing this with Linq tp SQL, since i am querying a cached Datatable and not tables from aDatabase

thanks

Hi I have been able to get past the first error that says my "datasource does not support Server-side paging" the issue i now have is displaying my data in the Gridview

when i now  set the result set of the query as my datasource and bind it to to the gridview,  the gridview doesnot display any data, buti know there is data returned into the linq query around 10152 rows and 103 columns and i cross checked it with my query returned in the database so it is correct...so do i need to do anything else to see the data in the gridview, as the page returned is just blank.

DataSet ds = (DataSet) Cache["dsResult"];

//EnumerableRowCollection<DataRow> query

= from c in dt.AsEnumerable() select new

SecurityName = c.Field<string>("SecurityName"),

Product = c.Field<string>("Product"),

Location = c.Field<string>("Location"),

AvgBorrowCost = c.Field<decimal>("AvgBorrowCost"),

AvgBorrowRebate = c.Field<decimal>("AvgBorrowRebate"),

Price = c.Field<decimal>("Price"),

SettledValue = c.Field<decimal>("SettledValue"),

PendingValue1 = c.Field<decimal>("PendingValue1"),

NetValue1 = c.Field<decimal>("NetValue1"),

PendingValue2 = c.Field<decimal>("PendingValue2"),

NetValue2 = c.Field<decimal>("NetValue2"),

PendingValue3 = c.Field<decimal>("PendingValue3"),

NetValue3 = c.Field<decimal>("NetValue1"),

//pending and net 4 to 22 here

//enumerate values

//foreach (var c in query)

//{

// Debug.WriteLine("Contact ID: {0} Name: {1}, {2} Order ID: {3} Order date: {4:d} ",

// c.ContactID, c.LastName, c.FirstName,

// c.OrderID, c.OrderDate);

//}

i.e //do i need to do anything else here? please see my previous posting of the entire code above

Gridview.Datasource = query; .e //do i need to do anything else here? please see my previous posting of the entire code above

gridview.Databind();

thanks

What is the ID of your GridView? If it is "gridview" than you need to change this line:

Gridview.Datasource = query;

gridview.Datasource = query;

Hi Kipo,

thanks for your speedy reply i am now actually able to return  data but it takes avery long time as i have 10512 records and 103 columns,

this is the result set of the Linq query but i have implemented paging and sorting  programmatically, hence i am handling the sorting PageindexChanging evens like so:

so that it paginates in 50 rows per page

 what seems to happen is all the 10512 rows are returned...from the query which is now bound to my gridview

could you please show me how i can then filter the data returned from my cache into the datatable, i suppose this is using a where clause on my Linq query

DataSet ds = (DataSet) Cache["dsResult"]; //all 10512 rows + 103 columns

//EnumerableRowCollection<DataRow> query

var query // i think i need as where clause to filter data into the query that i will bind***

= from c in dt.AsEnumerable() select new

SecurityName = c.Field<string>("SecurityName"),

Product = c.Field<string>("Product"),

Location = c.Field<string>("Location"),

AvgBorrowCost = c.Field<decimal>("AvgBorrowCost"),

AvgBorrowRebate = c.Field<decimal>("AvgBorrowRebate"),

Price = c.Field<decimal>("Price"),

SettledValue = c.Field<decimal>("SettledValue"),

PendingValue1 = c.Field<decimal>("PendingValue1"),

NetValue1 = c.Field<decimal>("NetValue1"),

PendingValue2 = c.Field<decimal>("PendingValue2"),

NetValue2 = c.Field<decimal>("NetValue2"),

PendingValue3 = c.Field<decimal>("PendingValue3"),

NetValue3 = c.Field<decimal>("NetValue1"),

//pending and net 4 to 22 here

//enumerate values

//foreach (var c in query)

//{

// Debug.WriteLine("Contact ID: {0} Name: {1}, {2} Order ID: {3} Order date: {4:d} ",

// c.ContactID, c.LastName, c.FirstName,

// c.OrderID, c.OrderDate);

//}

Try with this:

        var query = (from c in dt.AsEnumerable()
                    select new
                    {
                        SecurityCode = c.Field<string>("SecurityCode"),
                        SecurityName = c.Field<string>("SecurityName"),
                        Currency = c.Field<string>("Currency"),
                        Product = c.Field<string>("Product"),
                        CountryIssue = c.Field<string>("CountryIssue"),
                        Location = c.Field<string>("Location"),
                        Tag = c.Field<string>("Tag"),
                        AvgBorrowCost = c.Field<decimal>("AvgBorrowCost"),
                        AvgLoanCost = c.Field<decimal>("AvgLoanCost"),
                        AvgBorrowRebate = c.Field<decimal>("AvgBorrowRebate"),
                        AvgLoanRebate = c.Field<decimal>("AvgLoanRebate"),
                        Price = c.Field<decimal>("Price"),
                        SettledTotal = c.Field<decimal>("SettledTotal"),
                        SettledValue = c.Field<decimal>("SettledValue"),
                        PendingDate1 = c.Field<decimal>("PendingDate1"),
                        PendingValue1 = c.Field<decimal>("PendingValue1"),
                        NetDate1 = c.Field<decimal>("NetDate1"),
                        NetValue1 = c.Field<decimal>("NetValue1"),
                        PendingDate2 = c.Field<decimal>("PendingDate2"),
                        PendingValue2 = c.Field<decimal>("PendingValue2"),
                        NetDate2 = c.Field<decimal>("NetDate2"),
                        NetValue2 = c.Field<decimal>("NetValue2"),
                        PendingDate3 = c.Field<decimal>("PendingDate3"),
                        PendingValue3 = c.Field<decimal>("PendingValue3"),
                        NetDate3 = c.Field<decimal>("NetDate1"),
                        NetValue3 = c.Field<decimal>("NetValue1"),
                        //pending and net 4 to 22 here
                        Total = c.Field<decimal>("Total")
                    }).Skip(50).Take(50);

Thanks i will give that a try and let you know

kind regards

thank you very much! the Skip and Take()   works !!! the only thing i am not sure of now is how to retrieve the next set of  N rows, from my page as i cannot see the page navigation for getting the next set of N rows

hence my question is do i still need to implement my Paging and Sorting  programmatically be handling the  Sorting and PageIndexChanging events to be able to sort and Page in my gridView?

or i no longer need to do this ...at least for the paging? but i still cant see the number pages for my N rows of pages for each set i.e the navigation at the bottom of the gridview or the directional link

 thanks

please see code below:

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

GridViewSortDirection = SortDirection.Descending;

else

/// <summary>

///

/// </summary>

/// <param name="sortExpression"></param>

/// <param name="direction"></param>

//DataTable dt = GetData().Tables[0];

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

Hi Kipo,

I am wondering if you could help me with this...I am quire new to linq and i am trying to construct a dynamic where clause

for my linq query now i have been looking all over the web for examples but i cant find anything that seem to work for me...

here is my query and i want my where clause to be composed of the following dynamic string returned by the method

CreateFilter():

this method builds up my query based on whether a user selected a series of drop down boxes and input data into text boxes or not .i.e it it does an AND or OR depending on what is selected or not selected

string[] words = createFilter().Split(new string[] { "\r\n" }, StringSplitOptions.None);

var queryWhere = dt.AsEnumerable();

String thisWord = word;

queryWhere = queryWhere.Where(Func<string>(word)(word.Contains(thisWord))); //this did not work!!!!! 6hours trying!!

IEnumerable<DataRow> query =

from c in dt.AsEnumerable()

//******************Different where clauses i was tring to use to make it work!!******************************************/

select c;

dtFormat = new DataTable();

if (dtFormat.Rows.Count != 0)

dtFormat = query.CopyToDataTable<DataRow>();

/// This Method builds the where Clause the LINQ Query

/// based on User selected criteria

/// <returns></returns>

StringBuilder filter = new StringBuilder();

string ValueDate = msddlValueDate.List.SelectedValue;

filter.Append("c.Field<string>(" + "ValueDate" + ") == msddlValueDate.List.SelectedItem.ToString() && \r\n ");

string Currency = msddlCurrency.List.SelectedValue;

string Product = msddlProduct.List.SelectedValue;

string CountryIssue = msddlCountry.List.SelectedValue;

string Location = msddlLocation.List.SelectedValue;

string Tag = msddlTag.List.SelectedValue;

Here is an example how you could solve your problem (it's LINQ 2 SQL, but I hope you'll get the general idea):

        NorthWindDataContext db = new NorthWindDataContext();
        var customers = from p in db.Customers
                        select p;
        if (DropDownList1.SelectedIndex > 0)
        {
            customers = customers.Where(o => o.CompanyName == DropDownList1.SelectedValue);
        }
        if (DropDownList2.SelectedIndex > 0)
        {
            customers = customers.Where(o => o.Country == DropDownList2.SelectedValue);
        }
        if (DropDownList3.SelectedIndex > 0)
        {
            customers = customers.Where(o => o.ContactTitle == DropDownList3.SelectedValue);
        }
        GridView1.DataSource = customers;
        GridView1.DataBind();

Hi Kipo,

Thanks for your speedy reply i really appreciate it, and i have seen an example like this before, but theonly thing is that i am using LINQ rather than linQ to SQL, hence my table is not

coming from a DataBase directly as i am now querying a DataTable, so how do i then construnct the Linq query?

can i do something like this code block:

/////////////////////////////////////////////////////Start//////////////////////////////////////////////////////////