Click here to Skip to main content
15,943,103 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
my webservice stored procedure is
CREATE PROC [dbo].[GetRolesForUser](@UserID int) as
Select,cast(iif(ISNULL(,0)>0,1,0) as bit)  as IsChecked, A.UserRoleName
From tblRole A LEFT JOIN tblUserRoles B on ( and B.UserID=@UserID)

and my client side code is:

vmsUri = new Uri("http://localhost:2233/iRentDataService.svc/");
            db = new iRentEntities(vmsUri);
            //var query = db.CreateQuery<GetRolesForUser_Result>("GetRolesForUser")
            //    .AddQueryOption("userid", 6);
            var query = db.Execute<GetRolesForUser_Result>(new Uri(string.Format("{0}GetRolesForUser?userid={1}", db.BaseUri, 6), UriKind.RelativeOrAbsolute));
            GetRolesForUser_Result gc = new GetRolesForUser_Result();

config.SetServiceOperationAccessRule("GetRolesForUser", ServiceOperationRights.All);

<pre lang="xml">

this way i exposed dataservice :

        public IQueryable&lt;GetRolesForUser_Result&gt; GetRolesForUser(int userid)
            return this.CurrentDataSource.GetRolesForUser(userid).AsQueryable &lt; GetRolesForUser_Result&gt;();

            //return this.CurrentDataSource.GetRolesForUser.where(&quot;it.userid=@userid&quot;, new ObjectParameter(&quot;userid&quot;, userid));

The result is coming in browser :
<a href="http://localhost:2233/iRentDataService.svc/GetRolesForUser?userid=6">
how an i call at client side and bind to datagrid ..please help..thanx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900