在linq中返回数据集 [英] Return dataset in linq
本文介绍了在linq中返回数据集的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我尝试使用linq在web方法中返回数据..还有我在jquery中绑定网格视图
我尝试过:
更新后的代码
< script type = text / javascript>
var strArray = [['sfdsdfLi',9],['Kiwsdfi',3],['Mixesdfd nuts',1],['Oranges',6],['Grapes(束)',1]] ;
$( function (){
$(' [ID * = search_data]')。on(' click', function (){
var from = $(' [ID * = fromdate]')。val();
var to = $(' [ID * = todate]')。val();
var reg = $(' [ID * = regiondrop]选项:选择')[ 0 ]。value;
var obj = {};
obj.fdate = from;
obj.tdate = to;
obj.region = reg;
Getdata(obj);
返回 false ;
});
});
$( function (){
$(' < span class =code-string> [ID * = search_data]')。on(' click ', function (){
var fromdate = $(' [ID * = fromdate]')。val();
var todate = $(' [ID * = todate]')。 val();
var regiondrop = $(' [ID * = regiondrop]选项:选择')[ 0 ]。value;
var GridView1 = $(' [ID * = GridView1]');
var obj = {};
obj.fdate = from;
obj .tdate = to;
obj.region = reg;
Getdataa(obj);
});
});
function Getdataa(obj){
// alert('1');
$ .ajax({
type: < span class =code-string> POST,
url: WebForm1.aspx / search_data,
数据: {'fromdate':' + fromdate + ','todate':' + todate + ','regiondrop':' + regiondrop + '},
contentType: application / json ; charset = utf-8,
dataType: json,
async: true ,
cach e: false ,
成功:功能(结果){
$(< span class =code-string> #GridView1)。empty();
if (result.d.length> 0 ){
$( #GridView1)。append(
< tr>< th>所有者名称< / th>< th> Reg No< / th>< th>里程累积< / th><的第i; MAXSPEED< /第>中跨度>);
for ( var i = 0 ; i< result.d.length; i ++){
$( #GridView1)。append( < tr>< td> +
data.d [i] .OwnerName + < / td>< td> +
data.d [i] .RegNo + < / td>< td> +
data.d [i] .MileageAccumlation + < / td>< ; td> +
data.d [i] .MaxSpeed + < / TD>< / TR>中跨度>);
}
}
else {
$( #GridView1)。hide();
$( #Label1)。text( 无数据);
}
},
错误: function (错误){
alert( 错误);
}
});
}
function Getdata(obj){
// < span class =code-comment> alert('1');
$ .ajax({
type: POST,
url: WebForm1。 aspx / GetVo,
data: JSON .stringify(obj),
contentType: application / json; charset = utf-8,
dataType: json,
async: true ,
cache: false ,
成功: function (结果){
// alert(result.d);
// alert('2');
strar r = result.d;
var myarr = strarr;
Drewchart(myarr);
// alert(myarr);
// alert('3');
},
错误: function (错误){
alert( error跨度>);
}
});
}
function Drewchart(结果){
$(' #container')。highcharts({
chart:{
type:' pie',
options3d:{
enabled: true ,
alpha: 45
}
},
title:{
text:< span class =code-string>' 图表内容
},
副标题:{
text :' Highcharts中的3D甜甜圈'
},
plotOptions:{
pie:{
innerSize: 100 ,
深度: 45
}
},
系列:[{
name:' 已交付金额',
数据:结果
}]
});
}
webmthod
[WebMethod]
[WebMethod]
public static DataTable search_data(DateTime fromdate,DateTime todate, string regiondrop)
{
try
{
TrackDataEntities1 ts = new TrackDataEntities1();
var dq =( from vv in ts.tblVe
join rv in ts.tblReg on vv.ID equals rv .ID
join re 在 ts.tblRegi上rv.RID等于re.RID
其中
re.Region == regiondrop
&& re.StartDate < = fromdate
&& re.EndDate > = todate
orderby
vv.ID,
rv.OwnerName
选择 new
{
ID = vv.ID,
oname = rv.OName,
RegNo = rv.RegNo,
Speed = rv.Speed,
});
DataTable dt = new DataTable();
dt.Rows.Add(dq);
return dt;
}
catch (例外)
{
throw new 异常();
}
}
此节目错误
WebForm1.aspx:70未捕获的ReferenceError:未定义regiondrop
http:// localhost:33578 / WebForm1.aspx / GetVo无法加载资源:服务器响应状态为500(内部服务器错误)
解决方案
( function () {
(' [ID * = search_data]') .on(' 点击',功能 (){
var from =
(' [ID * = fromdate]')。val();
var to =
i try to return data in web method using linq .. and also i bind grid view in jquery
What I have tried:
UPDATED CODE
<script type="text/javascript">
var strArray = "[['sfdsdfLi', 9],['Kiwsdfi', 3],['Mixesdfd nuts', 1],['Oranges', 6],['Grapes (bunch)', 1]]";
$(function () {
$('[ID*=search_data]').on('click', function () {
var from = $('[ID*=fromdate]').val();
var to = $('[ID*=todate]').val();
var reg = $('[ID*=regiondrop] option:selected')[0].value;
var obj = {};
obj.fdate = from;
obj.tdate = to;
obj.region = reg;
Getdata(obj);
return false;
});
});
$(function () {
$('[ID*=search_data]').on('click', function () {
var fromdate = $('[ID*=fromdate]').val();
var todate = $('[ID*=todate]').val();
var regiondrop = $('[ID*=regiondrop] option:selected')[0].value;
var GridView1 = $('[ID*=GridView1]');
var obj = {};
obj.fdate = from;
obj.tdate = to;
obj.region = reg;
Getdataa(obj);
});
});
function Getdataa(obj) {
//alert('1');
$.ajax({
type: "POST",
url: "WebForm1.aspx/search_data",
data: "{'fromdate':'" + fromdate + "','todate':'" + todate + "','regiondrop':'" + regiondrop + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
async: true,
cache: false,
success: function (result) {
$("#GridView1").empty();
if (result.d.length > 0) {
$("#GridView1").append(
"<tr><th>Owner Name</th><th>Reg No</th><th>Mileage Accumlation</th><th>MaxSpeed</th>");
for (var i = 0; i < result.d.length; i++) {
$("#GridView1").append("<tr><td>" +
data.d[i].OwnerName + "</td> <td>" +
data.d[i].RegNo + "</td> <td>" +
data.d[i].MileageAccumlation + "</td> <td>" +
data.d[i].MaxSpeed + "</td></tr>");
}
}
else {
$("#GridView1").hide();
$("#Label1").text("No Data");
}
},
error: function (error) {
alert("error");
}
});
}
function Getdata(obj) {
//alert('1');
$.ajax({
type: "POST",
url: "WebForm1.aspx/GetVo",
data: JSON.stringify(obj),
contentType: "application/json; charset=utf-8",
dataType: "json",
async: true,
cache: false,
success: function (result) {
//alert(result.d);
//alert('2');
strarr = result.d;
var myarr = strarr;
Drewchart(myarr);
// alert(myarr);
// alert('3');
},
error: function (error) {
alert("error");
}
});
}
function Drewchart(result) {
$('#container').highcharts({
chart: {
type: 'pie',
options3d: {
enabled: true,
alpha: 45
}
},
title: {
text: 'Contents of Charts'
},
subtitle: {
text: '3D donut in Highcharts'
},
plotOptions: {
pie: {
innerSize: 100,
depth: 45
}
},
series: [{
name: 'Delivered amount',
data: result
}]
});
}
webmthod
[WebMethod]
[WebMethod]
public static DataTable search_data(DateTime fromdate, DateTime todate, string regiondrop)
{
try
{
TrackDataEntities1 ts = new TrackDataEntities1();
var dq = (from vv in ts.tblVe
join rv in ts.tblReg on vv.ID equals rv.ID
join re in ts.tblRegi on rv.RID equals re.RID
where
re.Region == regiondrop
&& re.StartDate <= fromdate
&& re.EndDate >= todate
orderby
vv.ID,
rv.OwnerName
select new
{
ID = vv.ID,
oname = rv.OName,
RegNo = rv.RegNo,
Speed = rv.Speed,
});
DataTable dt = new DataTable();
dt.Rows.Add(dq);
return dt;
}
catch (Exception)
{
throw new Exception();
}
}
this show error
WebForm1.aspx:70 Uncaught ReferenceError: regiondrop is not defined
http://localhost:33578/WebForm1.aspx/GetVo Failed to load resource: the server responded with a status of 500 (Internal Server Error)
解决方案
(function () {
('[ID*=search_data]').on('click', function () { var from =
('[ID*=fromdate]').val(); var to =
这篇关于在linq中返回数据集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文