Security :: AspNetSqlProvider Creating Roles At Runtime?
Mar 31, 2011
I've an ASP.NET MVC web site and I'm using AspNetSqlProvider to configure Secutiry
So, I runned aspnet_regsql command to create and configure aspnetdb database that hold users, roles , etc....
I use the asp.net application web management to create roles, users , etc... Ok
But I would like to create roles at runtime :
- If a new user visit my application, I would like to register it as a user and affect it a role ( Visitors)
- If a seller N visit my application, I would like to create a role ( seller N) to register the vositor as admin of seller N
How can we manager this scenario using my configured database aspnetdb ?
View 1 Replies
Similar Messages:
Jan 6, 2011
I am working on an Ecommerce website. I have created a database using Server Explorer named 'MyTestStore' and created Tables and Stored procedures inside it.
Than I used the program called aspnet_regsql.exe (which is in:
C:windowsMicrosoft.NETFrameworkv2.0.50727) to create the membership and roles tables. And this tool created all the membership tables in the MyTestStore database. All is fine till this point.
Enabling Roles:
Now I need to enable roles, insert admin and users into this membership tables in my database. so I opened up ASP.Net Configuration Tool but when I enable and create roles it automatically creates a database called ASPNETDB under App_Data folder whereas, I want to have the roles enabled in the database MyTestStore. But it keeps creating the database ASPNETDB. How do Imap the ASP.Net configuration Tool to create and add users into my database called MyTestStore instead of that default ASPNETDB.
View 6 Replies
Dec 16, 2010
I've created an ASP.Net 4.0 web application. It uses Forms Authentication. I have an ASPNETDB.mdf file in my App_Data folder courtesy of SQLEXPRESS. I have appropriate settings in my web.config for connection strings and providers (since I know it will be asked for:
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>).
I have roles and users setup. I have been running this with absolutely no problems in both my dev environment (i.e. Cassini) and on a "production" (not really, but a machine that was published to). And the "production" machine still has no problems.
So, everything has been working perfectly fine until early this afternoon and all of a sudden it all stopped. The only things I did from when it worked until it stopped was: I connected to and checked in all my code to a TFS server (2010) and then I updated namespaces all around. I have not made any changes to my web.config since it worked, nor to the database. I'm really not sure what happened. Oh, and the "production" machine never got the namespace updates. But, it did get a publish immediately before I uploaded everything into TFS.
It started with me getting a login failure in my app. I know the login is correct (it still works on the published system). So, I went into the Website Admin Tool and clicked onProvider Configuration -> Select a single provider... -> Click on Test next to AspNetSqlProvider (only option). I get back an error: "Could not establish a connection to the database." So, this tells me that for some reason, it can't see my database. All my roles and users still show up though in Security.
Since these two actions, I have wiped out all my code locally and refreshed from the first changeset in TFS. Still no workie. I still get the "Could not establish..." in WAT. Every post I can find online keeps talking about connectionStrings and database configuration (i.e. aspnet_regsql). However, since this was just working with no issues, I'm pretty sure none of these are my problem. Especially since I refreshed my code to an earlier "working" state (prior to namespace changes) to no effect.
I am not yet at the point that I'm willing to wipe my database and start over. Again, because this was working before. I have noticed and read several posts by Sukumar Raju among others (including his blog posts, one here) and none of them helped or were quite related to my specific issue. Good information, but not what I needed.
I'm sure something went offline somewhere and I can't see it. I did check to make sure that the SQLEXPRESS services (including Browser, etc.) were started. Even restarted them to no avail. I'm sure it has to be something simple and I'm just missing it somewhere.
View 2 Replies
Jan 23, 2010
1. On OnCreatedUser event, I create a folder for each members, so that they can store their files inside those. The thing is I use User.Provider key as a folder name. Is this a good way to store? Is this OK from security view point. Otherwise I am planning to use the User.Username. Here are the codes inside the OnCreatedUser event.
[Code]....
2. Inside these user folders I want to put web.config at run time [at the time of registration]. So that a member cannot access files of other members at any cost. Do you have any idea on creating web.config file at runtime inside these folders? Else if you can provide me any other options, I am eager to listen that. I don't want to call database frequently. So if there is any easy solution.
View 3 Replies
Jan 30, 2010
Sometimes MS provides error message so silly that its hard to understnad and you feel like throwing away all things.
My Web.Config does not contain any entries of MemberShip, Role or Profile.
I want to create a membership provider dynamically through code at runtime. I wrote following code and it receives following error message. I don;t know how come machine.config error appears in my application. how annoying.
Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.
Source Error:
[Code]....
Source File: C:WindowsMicrosoft.NETFrameworkv2.0.50727Configmachine.config Line: 139
Following is the CODE.
[Code]....
View 22 Replies
Mar 7, 2011
I have a multi level application that I am developing and need to block multiple rows from being joined. I know how to hide one role but I cannot figure out how to hide multiple.
Here is my current code
[Code]....
View 2 Replies
May 17, 2010
Newb question: what is the standard practice for assigning roles to newly signed-on members. Is it usually manual or is there a way of automatically assigning roles. Being completely new to this, I am confronted by the issue of my site having three different roles that new members could fall into, but am unsure about how to assign each a role. I can't imagine having to go through the process manually if I have thousands of members.
View 6 Replies
Jul 26, 2010
i am using asp.net built-in membership and role provider.
In my application Admin Create account for user.
currently i am assigning roles by going to asp.net configuration website.
kindly tell me how to add an extra step of Select Role in creat user account API.
View 2 Replies
Mar 8, 2010
Because of firewall issues, I have to have all of my database access on my production machine run through a wcf service. I've done this without problem throughout my site, but the issue remains for the AspNetSqlProvider provider. Is there a way to connect to the AspNetSqlProvider through a service?
View 1 Replies
Apr 24, 2010
[ASP.NET 3.5, FormsAuthentication, SQL Server]
In the Roles table there is Role, and RoleType.
I have 3different roles, 2 of which have sub-roles.
Example
Role----------------------Type
Adminstrator
Subscriber---Basic
Subscriber---Business
I need to implement Code Access Security, and URL based security using the roles & types...
For instance, the (Subscriber/Basic) would need to view a different set of pages, and have different access to things then a (Subscriber/Business).
I think I can handle the Code Access security with a custom attribute, but I am unsure to how enforce a User be apart of 2 roles in the URL Authorization.
I am currently using the web.config to deny/allow access to the directories/pages.
e.g.
/Areas/Admin/web.config
[Code]....
Is it possible to force the user to be apart of 2 roles with this technique?
View 1 Replies
Jan 14, 2011
I have a DataTable where the columns are generated programmatically at runtime. I then bind this DataTable to a GridView. What I'm wondering is how I can create the GridView to accommodate this, and if it's not possible, how I can output the DataTable into nicely formatted HTML.
View 3 Replies
Jan 21, 2011
Newbie in using AJAX . Programming in C# and using SQL as a database. Here is my scenario. User selects a project and I want to display the subprojects related to that project. Here is the query I use to retrieve subprojects.
"SELECT SubProjectName,StartDate,Description FROM SubProject WHERE ProjectName'"+ddlProjectName.text+"';
Currently I store the results of the query in a Dataset. I want to get the SubProjectName in the Header of the Accordion and StartDate and Description values to the text box for each accordion. ( This is what I need to do in each accordian for each subproject)
<asp:AccordionPane ID="AccordionPane2" runat="server">
<Header>
<a href="" onclick="return false;" class="accordionLink">SubProject 1</a>
</Header>
<Content>
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td class="td_left" colspan="2">
<asp:Label ID="Label1" runat="server" Text="Start Date"></asp:Label>
</td>
<td class="td_left" colspan="2">
<asp:TextBox ID="StartDate" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="td_left" colspan="2">
<asp:Label ID="Label2" runat="server" Text="Description"></asp:Label>
</td>
<td class="td_left" colspan="2">
<asp:TextBox ID="txtDecription" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</Content>
</asp:AccordionPane>
How can I do this? Some code example would be great on how to creat the accordinas ,text boxes dynamically and fill the values.
View 1 Replies
Jul 14, 2010
I have a Masterpage that has Treeview. You can select some nodes there. Based on the selection you get some items in the Default.aspx's Placeholder, you get a image and a linkbutton placed in a Panel. Like this :
This code is in the Default.aspx that has the Masterpage.
[Code]....
There seems to be problem when i create the controllers at runtime, when the site does a postback, lets say if i click "Enska" in the treeview i get the results in the image above. Lets say that i then click "The Punk Panther" i get a error.
An error has occurred because a control with id 'ctl00$CPH_Main$ctl05' could not be located or a different control is assigned to the same ID after postback. If the ID is not assigned, explicitly set the ID property of controls that raise postback events to avoid this error.
Also, how would i go by making a event handler for the linkbutton at runtime, can i make one event handler that every linkbutton uses or what ? I want the folder and the linkbutton to be clickable and link to the same place, is it simpler to make the whole Panel clickable, if so, how would i get a "OnClick" event on it ?
View 1 Replies
Aug 5, 2010
I have a requirement whereby one or more image buttons need to be created in a user control at runtime. The number of buttons is determined from a database where a user can add one or more rows that contain an image for each button, so if a user adds 3 images to a table, 3 image buttons are created. Ive used this code but I get an error at runtime
The control collection cannot be modified during DataBind, Init, Load, PreRender or Unload phases.
[Code]....
this is the usercontrol aspx
[Code]....
I basically want one or more buttons to render within the div in the usercontrol. Ive only got the code written for one button at the moment while I test the rendering, eventually they will be rendered in a loop of records taken from a database. Whats the best way to do this ?
View 2 Replies
Jan 9, 2010
I need to create aspx pages on the fly or at the runtime.I read that creating a template page and posting content to the page would be a solution, in a few posts in the forum. Can i get information on this method.
View 5 Replies
Mar 1, 2011
I want to create several instances of a webcontrol on my web page each time the user clicks an 'add' button.
HTML
[Code]....
c#
[Code]....
View 7 Replies
Aug 4, 2010
i am creating some of the control at runtime according database values. problem is that when i click onto the button, if the text box is empty, the required field validator(genrated at runtime) show first time that the text box is empty. but one agin i click on to the button, it doest show any error messege and all of the control which i am genrating at run time are hiding when i see at the page source, no control is find there.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using AjaxControlToolkit;
using click2install.controls;
public partial class FeebackForm_Client : System.Web.UI.Page
{
HtmlGenericControl table = new HtmlGenericControl("table");
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CreateForm();
}
}
public void CreateForm()
{
ds = DBManager.ExecuteDataset("[FeedBack_FeedbackDetail_get]");
for (int i = 1; i < ds.Tables[0].Columns.Count - 1; i = i + 4)
{
//CreateControl(txtAddress.Text.ToString(), txtAddressRun, false, false, txtAddressToolTip.Text, txtAddressWaterMark.Text);
string Name = ds.Tables[0].Rows[0][i].ToString().Replace(" ","");
if (Name != "")
{
TextBox txtControl = new TextBox();
//RequiredTextBox txtControl = new RequiredTextBox();
txtControl.ID = "txt" + Name;
txtControl.CausesValidation = true;
bool RequiredField;
bool ToolTip;
if (ds.Tables[0].Rows[0][i + 3].ToString() == "True")
{
RequiredField = true;
}
else
RequiredField = false;
if (ds.Tables[0].Rows[0][i + 1].ToString() != "")
{
ToolTip = true;
}
else
ToolTip = false;
string TooltipText = ds.Tables[0].Rows[0][i + 1].ToString();
string WaterMarkText = ds.Tables[0].Rows[0][i + 2].ToString();
CreateControl(Name, txtControl, RequiredField, ToolTip, TooltipText, WaterMarkText);
}
}
HtmlGenericControl tr = new HtmlGenericControl("tr");
HtmlGenericControl td1 = new HtmlGenericControl("td");
HtmlGenericControl td2 = new HtmlGenericControl("td");
HtmlGenericControl td3 = new HtmlGenericControl("td");
HtmlGenericControl td4 = new HtmlGenericControl("td");
Button btnInsertRun = new Button();
btnInsertRun.Text = btnSubmit.Text.ToString();
btnInsertRun.ValidationGroup = "Check";
td2.Controls.Add(btnInsertRun);
tr.Controls.Add(td1);
tr.Controls.Add(td2);
tr.Controls.Add(td3);
tr.Controls.Add(td4);
table.Controls.Add(tr);
pnlPreview.Controls.Add(table);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "Hide();", true);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "ShowAddDisability()", true);
}
public void btnInsertRun_Click(object sender, System.EventArgs e)
{
CreateForm();
//ds = DBManager.ExecuteDataset("[FeedBack_FeedbackDetail_get]");
//TextBox txt1,txt2,txt3,txt4,txt5=new TextBox();
//objBox2 = this.Page.FindControl("objBox2") as TextBox;
string ss = "txt" + ds.Tables[0].Rows[0][1].ToString();
//TextBox objTextBox = (TextBox)PnlControlPanel1.FindControl(strControlName);
TextBox txt1 = new TextBox();
txt1 = (TextBox)this.Page.FindControl("txt" + ds.Tables[0].Rows[0][1].ToString());
//txt1=this.pnlContainer.FindControl("txt"+ds.Tables[0].Rows[0][1].ToString()) as TextBox;
// txt2 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][5].ToString()) as TextBox;
// txt3 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][9].ToString()) as TextBox;
// txt4 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][13].ToString()) as TextBox;
// txt5 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][17].ToString()) as TextBox;
string fh = txt1.Text;
//DBManager.ExecuteNonQuery("Feedback_FeedbackInsert", ds.Tables[0].Rows[0][1].ToString(), txt1.Text,ds.Tables[0].Rows[0][5].ToString(), txt2.Text,ds.Tables[0].Rows[0][9].ToString(), txt3.Text,ds.Tables[0].Rows[0][13].ToString(), txt4.Text,ds.Tables[0].Rows[0][17].ToString(),
txt5.Text);
Response.Write("Ho Gya");
}
public void CreateControl(string Name, TextBox ControlID, bool RequiredField, bool Tooltip, string TooltipText, string WaterMarkText)
{
if (WaterMarkText == "")
WaterMarkText = Name;
HtmlGenericControl tr = new HtmlGenericControl("tr");
HtmlGenericControl td1 = new HtmlGenericControl("td");
HtmlGenericControl td2 = new HtmlGenericControl("td");
HtmlGenericControl td3 = new HtmlGenericControl("td");
HtmlGenericControl td4 = new HtmlGenericControl("td");
td1.InnerText = Name;
ControlID.ValidationGroup = "Check";
//ControlID.ValidatorMessage = Name + " is Required Field";
//ControlID.ValidatorDisplayType = ValidatorDisplay.Dynamic;
//ControlID.ValidatorEnableClientScript = true;
td2.Controls.Add(ControlID);
if (RequiredField == true)
{
//RequiredFieldValidator Valid = new RequiredFieldValidator();
//Valid.ID = "Valid" + Name;
//Valid.ControlToValidate = ControlID.ID.ToString();
//Valid.ErrorMessage = Name + " is Required Field";
//Valid.Text = "*";
//Valid.Display = ValidatorDisplay.Dynamic;
//Valid.EnableViewState = true;
//Valid.SetFocusOnError = true;
//Valid.Enabled = true;
//Valid.EnableClientScript = true;
//Valid.InitialValue = WaterMarkText;
//Valid.ValidationGroup = "Check";
//td3.Controls.Add(Valid);
}
if (Tooltip == true)
{
HtmlGenericControl span = new HtmlGenericControl("span");
//span.Attributes.Add("class", "hotspot");
span.Attributes.Add("onmouseout", "tooltip.hide();");
span.Attributes.Add("onmouseover", "tooltip.show('" + TooltipText + "');");
HtmlImage img = new HtmlImage();
img.Src = "info.png";
span.Controls.Add(img);
td4.Controls.Add(span);
}
//TextBoxWatermarkExtender WaterMark = new TextBoxWatermarkExtender();
//WaterMark.WatermarkText = WaterMarkText;
//WaterMark.EnableClientState = true;
//WaterMark.TargetControlID = ControlID.ID.ToString();
//WaterMark.Enabled = true;
//WaterMark.ID = "WaterMark" + Name;
//td1.Controls.Add(WaterMark);
tr.Controls.Add(td1);
tr.Controls.Add(td2);
tr.Controls.Add(td3);
tr.Controls.Add(td4);
table.Controls.Add(tr);
}
}
after rendring the page...
<div id="pnlContainer">
<table><tbody><tr><td>Email</td><td><input type="text" id="txtEmail" name="txtEmail"></td><td></td><td><span onmouseover="tooltip.show('Email');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>FirstName</td><td><input type="text"
id="txtFirstName" name="txtFirstName"></td><td></td><td><span onmouseover="tooltip.show('First Name');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>LastName</td><td><input type="text" id="txtLastName" name="txtLastName"></td><td></td><td><span
onmouseover="tooltip.show('Last Name');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>City</td><td><input type="text" id="txtCity" name="txtCity"></td><td></td><td><span onmouseover="tooltip.show('City');" onmouseout="tooltip.hide();"><img
src="info.png"></span></td></tr><tr><td>Address</td><td><input type="text" id="txtAddress" name="txtAddress"></td><td></td><td><span onmouseover="tooltip.show('Address');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr></tbody></table></div>
but after the click on to the button it shows only the container div..
<div id="pnlContainer"></div>
View 4 Replies
Mar 7, 2011
I want to create buttons and text boxs runtime and assigne to asp table.
When user clicks on button text box should be visible and user will be able to type some text and submit to server. This is nothing but something
like Blog. I am able to create asp table, button and testboxes but could not do visibility and events of buttons.
View 2 Replies
Nov 24, 2010
I'm having problems binding controls at runtime. I've some user controls which need to be bind to the page when one of the dropdownlist selected index changed.
I can able to bind them properly but when if there is any postback event happens I am losing the controls and control values which were created runtime.
How do I avoid binding them again and again.
View 3 Replies
Aug 6, 2010
I've an item template inside a grid which has a <asp:LinkButton/> inside it. I assign the text for the link button as
<%# Convert.ToString(Eval("Tags"))%>
Tags can have a string with multiple tags in it delimited by space. For eg. "sports", "sports cricket", "sports cricket sachin" are the examples of some possible tags.
I want to create a button for each tag inside the string. How can i create the controls (server control - linkbutton) dynamically during runtime inside the grid item template?
View 2 Replies
Jan 17, 2010
suppose that i have a gridview and an objectdatasource in my webform
with that i want to include several search criteria
the problem is that i want theme dynamic
for example
i have a dropdownlit with customers list
the first item in the dropdownlist is "All customers" for example
if i select it no "customer select parameter" is created
otherwise i have a "customer select parameter" for the objectdatasource and it's value is the dropdownlist.selectedvalue
View 2 Replies
Jan 7, 2010
I have used .net login control to authenticate user,i have three types of role ,role1,role2 and role3 and i have users and user have different roles.
now my requirement is like as per loggedin user i want to redirect user on particular page as per role.
for example if loggedin user role is role1 than he will redirect default1.aspx
for example if loggedin user role is role2 than he will redirect default2.aspx
for example if loggedin user role is role3 than he will redirect default3.aspx
and one question if same user may be have more than one role than what should happen???
I got a solution for same than if we are used "loggingin" event than it would be possible but i had placed login control in login view anonymous template because as per my requirement i want that after successfull login user can't see login control on page.thats why i didn't get the login control event on code.
View 6 Replies
Mar 22, 2010
In our system now, we have a class of user and beneath each class, there's a type of user.
Is there a way to setup and use the ASP.Net role provider with this kind of setup?
View 2 Replies
Feb 20, 2010
i am new to asp.net, i am creating a small website for my college, in that.
Only the admin's can create other users...
Now while using the nw registration wizard, i hav to mention the role also in that page.
View 5 Replies
Jun 10, 2010
can any one tell how to create the roles in asp.net? when ever Admin creates the roles, there it self he should assing the pages,which pages should be open when ever perticular person enters in to the site. When ever Admin wants to assing the Roles,all pages appear in grid view with check box,if he checks that pages,he able to access other wise he couldnot access that page.
View 1 Replies
