add role to new user from webpage

[moaa]

I have problem ,I have register new user by drag createuserwizard from login control
and it is save at ASPNET.mdf .and i create two role for the users.
I want to make this page when I create user choose too it's role
and save it at same database but i cann't
i want your help in it
thanks

[Frinavale]

I want to make this page when I create user choose too it's role
and save it at same database but i cann't

Why can't you?
What is the problem?
What have you tried so far?

[maliksleo]

@moaa
Dear please clerify yourself first that what you want.

What i understand is that you want the user to choose one of the two roles mentioned and with out choosing user will not be able to go forward.
Isnt it so?

if yes ten tell me i'll solve your problem or else clerify yourself

maliksleo

[moaa]

I create users && two roles (administrator&member) from asp.net conviguration
and it save at database called "aspnetdb.mdf" to make some pages that adminstrator only who use it ok!
and i make it, but the problem at when i create new user,he save it without it's role so,any new user can enter any page.
if I want to specify it's role make it from asp.net conviguration too.
but i don't want that
and when i drag CreateUserWizard from login control it haven't specify role
I hope to be understand my problem.

[maliksleo]

@moaa
i got your point
you need to make some changes first of all use checkbox list for your roles and on the coding side make it sure that your selected role is being stored in the database. How lets see:

*place checkboxlist from tool box to your aspx page and enter your roles in it like this
<asp:CheckBoxList ID="CheckBoxList1" runat="server" RepeatDirection="Horizontal">
            <asp:ListItem>Administrator</asp:ListItem>
            <asp:ListItem>Member</asp:ListItem>
        </asp:CheckBoxList>
 
*now in your coding side enter the selected value to the database through your query like
 
insert into "your database name" values ("your values" CheckBoxList1.selecteditem.text "this will insert the selected value in the database")
 
 
 

one more thing that you will have to check that weather the user comming on some page is authorized or not for that you will need authentication. You can do it by using sessions
when some user login check that weather its Admin or member by the value stored in database under the column role.
next is you need to store that role in a session and match it on every session for authentication.
i think thats what you want
maliksleo

[moaa]

thanks,maliksleo
I did that but there is problem at sql statment i cann't write it because the database "aspnetdb.mdf" it have three tables
1-table1 have(RoleName,RoleId)
2-table2 have(UserName,UserId,.....)
3-table3 have(UserId,RoleId)
and to insert role of user it must take it's UserId from table2 and take it's RoleId from table1 and insert that at table3
i did dataset but i coudn't complete it

[maliksleo]

@moaa
Its realy simple

on your registeration of user check the role selected and insert it in database like this:

* here txtuname is your userid and chklistrole is your role checkboxes
for table2
sqltext = "inser into table2 values ('" & txtuname.text & "',....")"
for table3
sql1text = "insert into table3 values('" & txtuname.text & "','" & chklistrole.selecteditem.value & "')"
note: you have to bind the roleid from database with the value property of chklistrole and text with the text property of chklistrole