使用LINQ to Sql使用带有参数的storeprocedure填充gridview [英] using LINQ to Sql to populate gridview using storeprocedure with parameters

问题描述

我正在尝试使用LINQ从storeprocedure填充gridview。我创建了storeprocedure并将其拖动到.dbml文件。



我的商店流程如下：

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();

它没有显示任何错误，甚至可以填充数据。请帮我用LINQ to Sql Class用store proc填充gridview。

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

推荐答案

你好，



尝试修改LINQ查询，如下所示。

Hi,

try by modifying the LINQ query like below.

var report = (from r in db.sp_getReportDateWise(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)) select r).CopyToDataTable();

，同时确保程序提供结果集并且gridview具有绑定字段或模板字段。



希望它有所帮助。

also, make sure the procedure is giving result set and the gridview is having bound fields or template fields.

hope it helps.

这篇关于使用LINQ to Sql使用带有参数的storeprocedure填充gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！