Click here to Skip to main content
13,091,300 members (52,102 online)
Rate this:
Please Sign up or sign in to vote.
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
Posted 6-Nov-12 1:56am

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100