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



and my client side code is:

XML
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 :


[WebGet]
        public IQueryable&lt;GetRolesForUser_Result&gt; GetRolesForUser(int userid)
        {
            return this.CurrentDataSource.GetRolesForUser(userid).AsQueryable &lt; GetRolesForUser_Result&gt;();
                //.GetRolesForUser(userid).AsQueryable&lt;GetRolesForUser_Result&gt;();


            //return this.CurrentDataSource.GetRolesForUser.where(&quot;it.userid=@userid&quot;, new ObjectParameter(&quot;userid&quot;, userid));
            //.GetRolesForUser(userid)
            //.AsQueryable();
        }
</pre>


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
Posted

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