Return dataset in linq

scropio gurl

10y2.2kLINQ

i try to return data in web method using linq .. and also i bind grid view in jquery


$(document).ready(function () {  
         BindGridView();  
  
     });  
     function BindGridView() {  
         $.ajax({  
             type: "POST",  
             url: "WebForm1.aspx/search_data",  
             data: JSON.stingify(obj),  
             data: "{'fromdate':'" + fromdate + "','todate':'" + todate + "','regiondrop':'" + regiondrop + "','GridView1':'" + GridView1 + "'}",  
             contentType: "application/json; charset=utf-8",  
             dataType: "json",  
             async: true,  
             cache: false,  
             success: function (result) {  
                 $("#GridView1").empty();  
                 if (data.d.length > 0) {  
                     $("#GridView1").append(  
                 "Owner NameReg No");  
  
                     for (var i = 0; i < data.d.length; i++) {  
                         $("#GridView1").append("" +  
                 data.d[i].OwnerName + " " +  
                 data.d[i].RegNo + " " +  
                   
                     }  
                 }  
             }  
         });  
     }

webmethod

[WebMethod]
public static string search_data(DateTime fromdate, DateTime todate, string regiondrop)
{
try
{
TrackDataEntities1 ts = new TrackDataEntities1();
var dq = from table //here is LINQ query which is long so i did not paste ..... .ToList();
DataSet ds = new DataSet();
dq(ds);
return ds;
}
catch (Exception)
{
throw new Exception();
// GridView1.Visible = false;
// Label4.Text = ("No Data");
}
}

this show error
Error 3 'dq' is a 'variable' but is used like a 'method'
Error 4 Cannot implicitly convert type 'System.Data.DataSet' to 'string'

so how i return this

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Soumalya Das10y ago
follow this link
http://www.c-sharpcorner.com/blogs/use-of-linq-to-dataset-with-example1
scropio gurl10y ago
@
Manas Mohapatra
exact issue is in dq there is json data and i have to convert this data and then i want to display this in gridview upon regiondrop and from date , to date selection..

and this is the whole jquery
<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 obj={};
         //             //       obj.fromdate=$("[id*=fromdate]").val());
         //             //       obj.todate=$("[id*=todate]").val());
         //             //       obj.regiondrop=$("[id*=regiondrop]").val());
         //             //       obj.GridView1=$("[ID*=GridView1]").val());
         //             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);

         $.ajax({
             type: "POST",
             url: "WebForm1.aspx/search_data",
            // data: JSON.stingify(obj),
             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 (data.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 < data.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>");
                     }
                 }
             }
         });
     });

     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
             }]

         });
     }

</script>
Manas Mohapatra10y ago
What is the exact issue now? Please mentionit where did you get stucked?
scropio gurl10y ago
@
Manas Mohapatra
i want to convert json to datatable
scropio gurl10y ago
@Manas Mohapatra
there is 4 paramters in jquery
- fromdate
-todate
-regiondrop
nad gridview
but here i how i pass gridview paramter because i already bind gridview in jquery
Manas Mohapatra10y ago
Find below steps to resolve problems:

Make your AJAX request correct means you are passing more no of params to webmethodbut webmethod receives only 3 params. So it throws you exception. To make sure that AJAX request is correct put a break point near to web method and see it if it hits.

If above step works then make sure you getting result(no of records) in your Linq.

Either you can send result as List

http://www.dotnetodyssey.com/2015/01/16/datatable-json-using-datatable-data-display-table-using-jquery-ajax-asp-net/

or

Convert DataSet object to Json

http://stackoverflow.com/questions/21015429/how-to-work-with-c-sharp-datatable-in-jquery-ajax-in-asp-net-webform
scropio gurl10y ago
i use this webmethod for bind gridview through this jquery code
$(document).ready(function(){
BindGridView();
});
functionBindGridView(){
//$('[ID*=search_data]').on('click',function(){
////varobj={};
////obj.fromdate=$("[id*=fromdate]").val());
////obj.todate=$("[id*=todate]").val());
////obj.regiondrop=$("[id*=regiondrop]").val());
////obj.GridView1=$("[ID*=GridView1]").val());
//varfromdate=$('[ID*=fromdate]').val();
//vartodate=$('[ID*=todate]').val();
//varregiondrop=$('[ID*=regiondrop]option:selected')[0].value;
//varGridView1=$('[ID*=GridView1]');
//varobj={};
//obj.fdate=from;
//obj.tdate=to;
//obj.region=reg;
//Getdataa(obj);
$.ajax({
type:"POST",
url:"WebForm1.aspx/search_data",
data:JSON.stingify(obj),
data:"{'fromdate':'"+fromdate+"','todate':'"+todate+"','regiondrop':'"+regiondrop+"','GridView1':'"+GridView1+"'}",
contentType:"application/json;charset=utf-8",
dataType:"json",
async:true,
cache:false,
success:function(result){
$("#GridView1").empty();
if(data.d.length>0){
$("#GridView1").append(
"OwnerNameRegNo");
for(vari=0;i
$("#GridView1").append(""+
data.d[i].OwnerName+""+
data.d[i].RegNo+"");+

}
}
}
});
}
here fromdate and todate is calendar
with above jquery code adn this webmethod code
[WebMethod]
public static DataTable search_data(DateTime fromdate,DateTime todate,string regiondrop)
{
try
{
T1ts=newT1();
var dq=(from vv in ts.tblVe
join rvin ts.tblRevonvv.ID equals rv.ID
join rein ts.tblRionrv.RID equals re.RID
where
re.Region==regiondrop
&& re.StartDate <= fromdate
&& re.EndDate >= todate
orderby
vv.ID,
rv.OwnerName
select new
{
ID=vv.ID,
ownername=rv.OwnerName,
RegNo=rv.RegNo,
}).ToList();
//DataSetdata=JsonConvert.DeserializeObject(dq);
//DataTabledt=(DataTable)JsonConvert.DeserializeObject(json,(typeof(DataTable)));
DataTable ds=new DataTable();
return ds;
}
catch(Exception)
{
throw new Exception();
//GridView1.Visible=false;
//Label4.Text=("NoData");
}
}
when i run this code and try to click fromdate calendar then calendar not visible where i also use this
"text/javascript">
$(function(){
$("#fromdate").datepicker();
$("#todate").datepicker();
});
check this
Bikesh Srivastava10y ago
ok follow these step:-
1:- use datatable instead of dataset because there are no need to use dataset.
2:-take take dq value in datatable using foreach loop not directly.
3:-use return type datatable.
it'll resolve your problem.
Vinay Singh10y ago
Hi
As said above have a look of the use dataset or list as a return . have a look the below link for help
http://www.aspdotnet-pools.com/2014/08/autocomplete-textbox-using-jquery-in.html
scropio gurl10y ago
i did but still errors
Bikesh Srivastava10y ago
use return type DataSet instead of String
try it.

Return dataset in linq

@Manas Mohapatra