I know ig grid needs a IQueryable object.

I know you apend the paging function in GridDataSourceAction aginst Linq. 

My question is that I only have some sql now. How can I convert these SQL to an IQueryable object, and I don't want to lost the delay query feature.

For example. I have "Select * from Issues''. Issues table has a lot of rows, So I need the paging feature.

following is the code I want:

[GridDataSourceAction]
[ActionName("PagingGetData")]
public ActionResult PagingGetData()
{
 var ds= ConverSqlToQuerable(" I have "Select * from Issues'"); 

   //Here, I don't want query data from DB.
   //I have a lot of Rows in DB. So I need deley DB query 
   // until GridDataSourceAction appends the
   // paging filter at the tail of my sql.

    return View("RowSelection", ds);
}

My question looks like an Linq question more. But I'm hoping get some suggestion from your guys.

Thank you!.

you don't need to use the MVC extensions or LINQ in order to bind a simple client-side grid (pure client side, no .NET Code) to an SQL backend. you just need to create a REST service which returns the results from the SQL query in JSON arrays, and set the dataSource of the grid to the URL of your service. you can find various tutorials on the web which show how to create REST web services with either .NET or some other backend (such as PHP). You can use a SqlDataAdapter to fill a DataSet from your query and then build a list of business objects (plain class with properties corresponding to the columns). then the resulting list will be automatically serialized by the service. - in case you're using a WCF service, for instance.

 DataSet ds = new DataSet();
                using (SqlDataAdapter da = new SqlDataAdapter(sqlCmd))
                {
                    da.Fill(ds, "Products");
                }

Hope it helps. Thanks,

Angel

You can read the feature parameters from the URL such as pageIndex and pageSize, and build your own query logic depending on your backend. In SQL this will translate to setting TOP/LIMIT clauses, ORDER BY, etc. 

With the MVC Wrappers you get this done for you, yes. 

Thanks,

Angel

By this way, we lost the server-side pagging,sorting...  right?