How to provide view add edit and delete permissions

Question

0.00/5 (No votes)

See more:

Hello Everyone,

I have an problem. I have a Database with 6 columns.1st column contains ID, Second Column contains Role_Name, third column is Checkin_Add,4th column is Checkin_View. And 5th column is Checkin_Edit and 6th column is checkin_Delete. In my Role.aspx page i have taken a gridview with datasource of this database. I have to create checkboxes for the columnd add ,edit,view, delete.and when i check the checkboxes database shoud be updated as yes else no. Which will be yes in the database only that access are provided to the authenticated users. how will i do it .Kindly help

Posted 7-Mar-14 0:12am

Member 10578683

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Amalraj Ramesh · Answer 1 · 2014-03-07T00:33:00

Solution 1

You have to create one more table in Db like tblfuncton and that should contains

all page information here

for example

FunID, FunName, Add, Edit, Delete, View, Print
001 Customerpage Y Y Y Y N
...
...
...

Then take this in list (only FunID,FunName) bind it in gridview with templatefeild(Add, Edit,Delete,View,Print) checkboxs

You have to map FunID to RoleID

Posted 7-Mar-14 0:33am

Amalraj Ramesh

Updated 7-Mar-14 0:35am

v2

Comments

Member 10578683 7-Mar-14 6:45am

Actually i have done one database Role in which I have columns such as Role_Id Role_Name Customerpage_Add, CustomerPage_Delete,customerPage_Edit,Productpage_Add,Productpade_View like this for all pages in one database. so here mapping is not required.My problem is how will i assign these roles to authenticated users. Suppose i have a role Supervisor. i want that supervisor can only view permission. the how will i map or do this

Amalraj Ramesh 7-Mar-14 7:09am

Thats fine.. U have to add new unique id for every role for example Admin=1,Supervisor=2 and map to userid

Amalraj Ramesh 7-Mar-14 7:10am

Can u give me some sample data for role table

Member 10578683 7-Mar-14 7:17am

Role_Id Role_Name CheckinPage_Add CheckinPage_delete CheckinPage_View Productpage_Add,
1 Admin chkbox1 chkbox2 checkbox3 checkbox4
2 User chkbox1 chkbox2 checkbox3 checkbox4
like this

Member 10578683 7-Mar-14 7:25am

how to map that is my problem can you give some code. i am new to this field

Amalraj Ramesh · Answer 2 · 2014-03-07T01:38:00

In Submit Button Click

SubmitButtonClick(.....)
{
DataTable dt = new DataTable();
dt.Columns.Add("Add");
dt.Columns.Add("Edit");
.
.
.
DataRow newrow = null;
foreach (GridViewRow row in grdID.Rows)
{
newrow = dt.NewRow();
if (((CheckBox)row.FindControl("ChkAdd") as System.Web.UI.WebControls.CheckBox).Checked == true)
newrow["Add"] = "Y";
else
newrow["Add"] = "N";

if (((CheckBox)row.FindControl("ChkEdit") as System.Web.UI.WebControls.CheckBox).Checked == true)
newrow["Edit"] = "Y";
else
newrow["Edit"] = "N";
.
.
.
.
dt.Rows.Add(newrow);
}

//finally all in thi dt
}