I'm using VWD 2010 asp.net 4.0 and SQL Server 2008 Express
I created a website that uses security with aspnetdb configuration
now I have hundred users that need to access this website
And I don't want manually insert them one by one
Is there any way (T SQL Stored Proc or ASP.NET VB code) to automated this bulk insert?
I currently have a website up and running and working correctly with godaddy.com using the out-of-the box authentication with an aspnetdb sqlserver database. I have users on this site and am very hesitant to change anything with this database or the web.config file from the working site for fear of wrecking it
So, my challenge is that I need to authenticate a separate application using the same aspnetdb.mdf file without any crossover to my 1st application. I've noticed that the ApplicationName that is currently in my aspnetdb database for the working application is just "/". I know that I'll need to have 2 separate entries in the aspnet_Applications table to define these two applications and then somehow register those names within their respective web.config files - but wanted to have step by step instructions on how to this so as to not "break" the 1st working application that is already live.
Can anyone point me to a document on what changes I will need to make?
Also, with the default create user wizards I'm using, how will it know to create the new user information with the correct application ID so that the user information from one application is not visible to managers of the second application and vice/versa?
I have an asp login control that uses the standard aspnet database structure.I am using my own user identification system to identify a user based on login values that are not in the aspnet database and setting the user's aspnet database login to a universal login user and password.this works fine and I am able to test this by having one machine log in as "User 1" and another login as "User 2" but I am wondering if there is a limit to the number of user's that can be assigned to one username and password in the aspnet database for website access?Will the system reach the max number of user's in the aspnet database?
View 2 RepliesI have 2 different website/applications with 2 different asp.net membership databases in the same server. Now my client wanted to create a user in one website and add that person automatically in to the other application/website/database too. Right now my applications create users using asp.net membership and added to its respective databases. Is it possible to create a user from different application using asp.net membership?
View 6 RepliesI am using ASP.NET Membership with the default provider. I have a project where there are 3 different applications(seperated by the applicationName). Now I need every user to be able to log in to all the applications, but have a seperate role in each.Is this possible(I dont want to duplicate user details or logins for the same person)?
View 4 Repliesi am managing three applications .. i hve separate pages in each of these applications for creating users and roles..
can i create a single page where in i can choose for which applications i want to create users..
i am storing the users of each of thse 3 applications in a same database and i hve separate application name for each application in membership provider
I have to update the users based on input value..
here is my code..
[Code]....
using this I can update only one user perfectly but I need to loo update all users based on generic Filedset values?
I have a web.config file with <authorization> section. I'm using window authentication.
The problem is that I would like to allow access to the web site to those users who are in multiple roles.
For example:
<authorization>
<allow roles = "Role1 AND Role2"/>
<deny users="*"/>
</authorization>
(Meaning I would like to allow access only to those user who are both in Role1 AND Role2.)
Is this possible to achive this?
If not, what would be the alternatives?
Note: Currently I'm doing the roles assignment in the Global.asax file in the OnAuthenticateRequest event (i'm reading the groups that the current user belong to in the Active Directory).
i am a new comer in asp.i needed asp code for sending bulk emails for various users.
View 1 RepliesI have users table in database that contain their Email address and I have 2 textbox
1-txtSubject
2-txtBody
and 1 button btnsend in my page...
I want when I click on Send button it send to all users email that contain txtsubject and txtbody ...
how I can do it?
I need to populate a dropdown list with users who match certain role criteria. For example, if I have the following roles: Manager, Employee, Supervisor I would like to populate the list with only the Manager and Employee roles. Some individuals have multiple roles and they should be excluded if they also have the Supervisor role as illustrated below:
Name: A , Role(s): Manager, Employee, Supervisor
Name: B, Role(s): Employee
Name: C, Role(s): Manager, Employee
The final list should only contain names B & C.
I can use Roles.GetUsersInRole("Employee") but I am not sure if this is efficient or not.
How can I load data from xml file into MSSQL Server using sql xml bulk load? I had try some code but when I ran my application, I encounter below error msg
"Retrieving the COM class factory for component with CLSID ...... failed due to the following error: 80040154"
How can I go about solving this?
I have CSV file i want to upload the CSV file data to my table, With file fileupload, below is my code
public void InsertAccounts()
{
con.Open();
SqlCommand cmd = new SqlCommand("BULK INSERT SN001CompanyTable FROM '" + System.IO.Path.GetFullPath(FileUpload1.PostedFile.FileName) + "' WITH (FIRSTROW = 2,FIELDTERMINATOR = ',',ROWTERMINATOR = '
')", con);
cmd.ExecuteNonQuery();
con.Close();
lblalert.Text = "Submitted";
}
After selecting file when i click on upload i am getting
Cannot bulk load. The file "C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDECompanyData_Format (1).csv" does not exist.
My CSV is on desktop, i dont know how fileupload take correct path -
Ive searched quite a while to do this.. havent found any revelant answer i already have a database named GAD.MDF with tables inside. However i wanna use the membership API to use the tables generated in the aspnetdb.mdf. Is there a way to generate thoses tables in my own database and then use my database instead? cause many host only enable us to use one database.
View 4 RepliesI used aspnet_regsql -W wizard approach to create DB for membership tables. and added script as follows in web.Config
[code]....
I'm just curious, why its not bigint or int ? is that because GUID is easy to generate ?
View 8 RepliesI have setup a Web Site Administration Tool for a web application and it work great
Now i have another custom application that was built on a different server and site but i want to use the users in the existingWeb Site Administration Tool for authentication and authorisation.So i deployed the custom application to the the same server where the Web Site Administration Tool resides. and just changed the connection string to point to the same database.But when i login with a username and pass it says login no correct.http://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication&applicationUrl=/myapplicationwhen i go to the link above it works and i can see all my usershttp://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication2&applicationUrl=/myapplication2When i go to this link i can't see users as its th new custom application i just moved to the site.
I get error There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem:Server cannot access application directory 'C:Inetpubmyapplication2'. The directory does not exist or is not accessible because of security settings.Is my approach a resonable one and is this possible?
In one of my web app's pages, the code behind needs to grab the UserId of the person logged in, so that it can then be inserted into a table which was added to the original aspnetdb.mdf. This table contains a column with a uniqueidentifier primary key which is in direct relationship with the aspnet_Users table; however I seem to have trouble retrieving the UserId. This table contains the additional information of a user which is not included in the provider, and it has a one-to-one relationship with aspnet_Users.
I hope this makes sense. I haven't written any code for it yet; I'm only at the thinking part of this stage. But my mind keeps going blank.(perhaps I need a break from the solution???).
I am using C# in my Web app's code behind.
I am getting to like how to use a profiles in aspnetdb membership
But these profiles are stores in a string.
Q: How does one get this profile data into a table, or get TSQL to show data in a column format.
I had a web application. We needed to move it to anotherserver, after we moved that, the membership database (aspnetdb) did not work.....finally i solved the problem, and now I have another problem. although in the web.config enablepasswordretrieval is set to true, and the type is clear, i get error in password retrieval.
View 7 RepliesI have developed a Silverlight app using forms authentication and the asp net membership, aspnetdb, the whole enchilada.The bug I see is that the password for my users change by them self every bow and then, the way I fix them is by deleting the user and creating them again, this has been I problem all the time.In a post I read the problem was manifesting because I didn't have a machineKey in my web.config, I now do, so I dunno what the problem is this time...Is there a definitive fix to this? can you please provide assistance?
View 11 RepliesI am using Visual Studio 2008 Express.
I did this simple test:
I created a new Web project with a simple page that has a Log In. There were no databases in App_Data.
I used the configuration tool to create a Role and User.
I refreshed the project folder and behold AspNetDB.mdf has appeared in the App_Data folder.
I have checked the Web.Config file and there is NO Connection string to this database.
So how do I move the Roles/Users application data storage away from AspNetDB.mdf to my own database ?
I am creating a website, where my client is planning to target 1000's or user registrations with their login area etc. Is it a good idea to use role management/aspnetdb for this purpose?
View 9 RepliesI am in the begininng stages of designing (or redisigning) a site. I am using VWD Express 2010 and the project is configured for .net 4.0. I am designing it offline so its currently just on my laptop, which is also running sql server express 2008 R2.
When I ran the ASP.Net Configuration tool, it automatically created a database called aspnetdb in the app_data folder where it stores all the user and roll info. How can I use a different database that has the same schema as well as some additional tables of my own. I want to point it to mylocally running sql server.
Currently in security setting in website configuration, there us only User, Roles, And Access Rules.i want to add Groups as top level for Users. is it possible?
View 4 Replies