my webservice are not fetch data form database with linq

Gaurav Raj

9y859Learn iOS Programming

This is my webservice code

[WebMethod]

public Home getHome(int user) {

Home h = new Home();

Connection cs = new Connection();

var q=cs.da.HomeProcedure(user).ToList();

return h;

}

this is my home class

public class Home

{

public int BlogId { get; set; }

public string BlogPic { get; set; }

public string Title { get; set; }

public string Blogpic { get; set; }

public string Date1 { get; set; }

public string Time1 { get; set; }

public string Blogby { get; set; }

public string UserPic{get; set; }

public string TotalLike { get; set; }

public string TotalComment { get; set; }

public string LIKED { get; set; }

}

Output is

 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">

0

Please somebody help me

5 Replies

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

Gaurav Raj9y ago
public List getHome(int user)
{
Home h = new Home();
Connection cs = new Connection();
List list =cs.da.HomeProcedure(user).ToList()

return list;
}
This code is work but above code it not work
Sundaram Subramanian9y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
namespace WebService
{
///
/// Summary description for WebService1
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
[WebMethod]
public List GetStudents()
{
using (DemoDBEntities ctx = new DemoDBEntities())
{
var query = from q in ctx.Students
select q;
return query.ToList();
}
}
}
}

For more follow the link

https://forums.asp.net/t/1936566.aspx?c+net+web+service+to+get+data+from+sql+server

Thanks in Advance.
Gaurav Raj9y ago
My query statement is right ,
please give me a simple example post
Ramesh Barik9y ago
You are returning h object from the webmethod which is a object of Home class type.
Is h object contains data?.
I think in var q have some data of Home type as your calling the the procedure to get the data.
Check your q variable value if it has some data or not. if q is a Home type object then return q not h.
Rajkiran Swain9y ago
Check your Select statment Query ? Maybe something wrong in your query .

or

follow this link .

http://geekswithblogs.net/dotNETvinz/archive/2010/03/11/fetching-data-from-database-and-populating-fields-in-the-form.aspx