how to convert ISingleResult data into dataset and how to find column name using linq query

See more:

LINQ

Dear sir,


I am using VS 2008. I have to access my database(SQL Server 2008) with the help of LINQ in web application.

I have the following code in C# code behind file:

myDBDataContext db = new myDBDataContext;
var result = db.stored_procedure_get_name(int id);
gridview.datasource= result;
gridview.databind();

This works fine but I need the following code for next purpose:

Dataset ds= new dataset();
ds=result;  // the result is the value returned by LINQ (ISingleResult)
gridview.datasource= ds;
gridview.databind();

and the dbml file return the result as ISingleResult.

so can anyone tell me how to type cast ISingleResult to Dataset in C# for Visual Studio 2008