0

I have 2 tables that i have joined together to be able to evaluate the availabilty of rights to a user. the query is as below

SELECT R.RIGHT_ID,RIGHT_NAME,
RVIEW=CASE WHEN R.RIGHT_VIEW = 0 THEN NULL WHEN R.RIGHT_VIEW = 1 AND A.RIGHT_VIEW IS NULL THEN 0 ELSE A.RIGHT_VIEW END,
RADD=CASE WHEN R.RIGHT_ADD = 0 THEN NULL WHEN R.RIGHT_ADD = 1 AND A.RIGHT_ADD IS NULL THEN 0 ELSE A.RIGHT_ADD END, 
REDIT=CASE WHEN R.RIGHT_EDIT = 0 THEN NULL WHEN R.RIGHT_EDIT = 1 AND A.RIGHT_EDIT IS NULL THEN 0 ELSE A.RIGHT_EDIT END,
RDEL=CASE WHEN R.RIGHT_DELETE = 0 THEN NULL WHEN R.RIGHT_DELETE = 1 AND A.RIGHT_DELETE IS NULL THEN 0 ELSE A.RIGHT_DELETE END,
R.RIGHT_TYPE, A.RIGHT_VALUE
FROM RIGHTS_MASTER R LEFT JOIN
(SELECT RIGHT_ID,RIGHT_ADD,RIGHT_EDIT,RIGHT_DELETE,RIGHT_VIEW,RIGHT_VALUE
FROM ASSIGNED_RIGHTS_MASTER INNER JOIN USER_MASTER ON USER_MASTER.USER_ID = ASSIGNED_RIGHTS_MASTER.USER_ID
WHERE USER_MASTER.USER_ID = '4') A
ON R.RIGHT_ID = A.RIGHT_ID
WHERE R.RIGHT_MODULE = 'CF'
ORDER BY RIGHT_NAME

now i want to display this in a Radgrid with selectable checkboxes for view,add,delete and edit columns. These should display the value that is in the table for each of the columns.

below is the structure of the 2 tables used.

USE [LODGERMS_MAIN]
GO
/****** Object:  Table [dbo].[ASSIGNED_RIGHTS_MASTER]    Script Date: 03/21/2013 12:23:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ASSIGNED_RIGHTS_MASTER](
    [LODGE_ID] [nvarchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [USER_ID] [nvarchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_ID] [int] NOT NULL,
    [RIGHT_VALUE] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_EDIT] [bit] NOT NULL,
    [RIGHT_VIEW] [bit] NOT NULL,
    [RIGHT_DELETE] [bit] NOT NULL,
    [RIGHT_ADD] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ASSIGNED_RIGHTS_MASTER]  WITH NOCHECK ADD  CONSTRAINT [FK_ASSIGNED_RIGHTS_MASTER_PROPERTY_MASTER] FOREIGN KEY([LODGE_ID])
REFERENCES [dbo].[PROPERTY_MASTER] ([LODGE_ID])
GO
ALTER TABLE [dbo].[ASSIGNED_RIGHTS_MASTER] CHECK CONSTRAINT [FK_ASSIGNED_RIGHTS_MASTER_PROPERTY_MASTER]







USE [LODGERMS_MAIN]
GO
/****** Object:  Table [dbo].[RIGHTS_MASTER]    Script Date: 03/21/2013 12:25:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RIGHTS_MASTER](
    [RIGHT_ID] [int] IDENTITY(1,1) NOT NULL,
    [RIGHT_NAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_TYPE] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_VALUE] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_MODULE] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RIGHT_EDIT] [bit] NOT NULL,
    [RIGHT_VIEW] [bit] NOT NULL,
    [RIGHT_DELETE] [bit] NOT NULL,
    [RIGHT_ADD] [bit] NOT NULL,
 CONSTRAINT [PK_RIGHTS_MASTER] PRIMARY KEY CLUSTERED 
(
    [RIGHT_NAME] ASC
) ON [PRIMARY]
) ON [PRIMARY]

Please assist me as i am stuck on a project.

2
Contributors
4
Replies
16
Views
4 Years
Discussion Span
Last Post by LastMitch
0

now i want to display this in a Radgrid with selectable checkboxes for view,add,delete and edit columns.

You mean something like:

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/selectrowwithcheckbox/defaultcs.aspx

There's a reason why there's a demo for Radgrid to let you see how it works.

These links have code snippets which you can used for your querys:

http://www.telerik.com/community/forums/aspnet-ajax/grid/getting-the-radgrid-checkbox-column-value-in-server.aspx

http://www.telerik.com/community/forums/aspnet/grid/radgrid-checkbox-gridtemplatecolumn.aspx

0

what i require is that the checkbox be checked if the value in the DB is 1 and unchecked if the value is 0.

0

I have been able to resolve the above issue.

I only have one issue with the solution. I have an itemtemplate containing a textbox that is populated with data from the named database tables but for some reason i can't edit the content of the textbox.

Please help.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.