Wednesday, February 23, 2011

Get DataTable From Linq query

Here code example



public DataTable ToDataTable(System.Data.Linq.DataContext ctx, object query)
{

if (query == null)
{
 throw new ArgumentNullException("query");
}

 IDbCommand cmd = ctx.GetCommand(query as IQueryable);
 SqlDataAdapter adapter = new SqlDataAdapter();
 adapter.SelectCommand = (SqlCommand)cmd;
 DataTable dt = new DataTable("sd");

try
{
 cmd.Connection.Open();
 adapter.FillSchema(dt, SchemaType.Source);
 adapter.Fill(dt);
}

finally
{
 cmd.Connection.Close();
}

 return dt; 

} 

No comments:

Post a Comment

I Built a New Kind of Number Puzzle Game (And You Can Play It Free)

 For a long time, I wanted to play a mobile puzzle game that felt genuinely strategic—something that required real brainpower, skipped the a...