using LINQ to Sql to populate gridview using storeprocedure with parameters

See more:

C#

ASP

ASP.NET

LINQ

Gridview

, +

I am trying to populate gridview from storeprocedure using LINQ. I have created storeprocedure and dragged it to .dbml file.

My Store proc is as follow:

create proc sp_getReportDateWise
@fromDate date,
@toDate date
as select * from tblreport where Date BETWEEN @fromDate AND @toDate

In button click event i have the following code:

LinqSampleDataContext db = new LinqSampleDataContext();
var report = (from r in db.sp_getReportDateWise(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)) select r).ToList();
gridviewResult.DataSource = report;
gridviewResult.DataBind();

It shows no error and doest even populate the data. Please help me to populate gridview with store proc using LINQ to Sql Class.