How convert IQueryable to Dataset in LINQ to SQL

Question

1.00/5 (1 vote)

See more:

, +

In 3 layers project I get data with store procedure in data access layers and I want convert this to datatable(for bind in gridview).
IQueryable don’t supported from server side paging.

I found this way:

C#

public DataTable GetInfo(int Id)
{
   db = new DataClassesDataContext();
DataTable dt=new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
var query=db.spGetInf(id) .AsQueryable();
    var reader = value.GetEnumerator();

    while (reader.MoveNext())
    {
        var rw =reader.Current;
        dt.Rows.Add(rw.Id, rw.name);
    }

    return dt;
}

Posted 25-Jul-14 16:33pm

m.kolbadi

Updated 10-Dec-19 4:02am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nathan Minier · Answer 1 · 2014-07-28T02:39:00

Solution 1

There's quite a bit of information on how to provide backwards compatibility to ASP.NET gridviews from LINQ out there, specifically have a look at this thread:
http://stackoverflow.com/questions/1595350/why-am-i-not-getting-copytodatatable-in-linq-query[^]

Posted 28-Jul-14 2:39am

Nathan Minier

Comments

m.kolbadi 29-Jul-14 0:48am

it work but i have one problem,I use Store procedure and your solution dosent work with SP

Nathan Minier 29-Jul-14 9:18am

I just spent a little time on it when I realized that I'm not nearly as familiar with LINQtoSQL as I should be. It looks like the common solution to to use an ObjectDataSource instead of the LinqDataSource in order to provide SP support. Your solution should be fine, but I would suggest a small change to it due to the Disposable nature of the DataContext.

public DataTable GetInfo(int Id)
{
using(var db = new DataClassesDataContext())
{
DataTable dt=new DataTable();
dt.Columns.Add(“ID”);
dt.Columns.Add(“Name”);
var query=db.spGetInf(id) .AsQueryable();
var reader = value.GetEnumerator();

while (reader.MoveNext())
{
var rw =reader.Current;
dt.Rows.Add(rw.Id, rw.name);
}

return dt;
}
}

This will allow the context to Dispose and will avoid some issues with unmanaged resources down the road.