when i am trying to add a database to new website using "ADD NEW item--->SQL server databse i am getting an error which is telling
"Generating user instances in SQLSERVER is disabled.Use sp-configure user 'user instances enabled' to generate user instances."
how to enable the user instance option and where i can find it?
It seems when I try to dynamically create multiple instances of a User Control, I get an Object Reference Not Set To An Instance Of An Object error on any ASP control that I'm using in that User Control
Here's the class where I'm creating them.
[Code]....
Am I able to successfully refer to a panel on the page that I'm calling this routine from simply by ByVal ... As Panel, or should I use HttpContext?
I have table called ROLE with fields (id,name,permission) example values (1001,madhu,hr)
I have another table called LOGIN with fields(id,DOB,password) example values(1001,24101989,madhukumar)
What i want is , if i login using the LOGIN table ,it check the id and permission in the ROLE table , if the permission is 'hr' it enable to access the menu , or if the permission is any other it just print the error message ("no permission")
Note: menu is placed in master page , but login is not in the master page ...
I have a user control that I place on a page severl times. When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl. So I get duplication of an insert that I do. Is there a ay to make sure these events are isolated so this doesn't happen.
View 8 RepliesI have an ASP.NET page inside of an ASP.NET Master page, and inside the page I have two instances of the same web user control. I have given them different IDs, but when I click a button on the first user control it causes the second user control to do the expected activity and the first one does nothing. Is there something I need to do to make sure that the controls don't get confused?
View 2 RepliesI have built a User Control in VB which displays two gridviews and allows a user to select an item in the first gridview and display multiple rows in the second grid with the key of the selected item from the first. The data to be displayed is passed to the User Control as a datatable object via a public property of the User Control.
The user control works perfectly, but to allow the the subs in the codebehind of the User Control to access the data set when the user control is initialised, I have declared them as "Private Shared".
Having got everything to work, I now want to display multiple instances of the same User Control with different datasets.
However, because my data objects are defined as "Private Shared" each instance of the user control is overwriting the data of the others.
I can fix this problem by removing the "Shared" keyword, and have also tried setting them to "Protected" instead but then my variables expire after being set and contain "Nothing" when I get to the "RowCommand" event in the Code Behind.
I'm sure I must be doing something stupid, because surely the whole idea of User Controls is to make reusable code drven by parameters.
Here is my code:
Main Program .aspx
[Code]....
Main Program Code Behind
[Code]....
User Control .ascx
[Code]....
User Control Code Behind
[Code]....
Quoted from http://blogs.msdn.com:
User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments.I have a server running Server 2008 R2 Web Edition with IIS 7.5 and Sql Server 2008 R2 Express installed.I have only 3 friends as my hosting clients. Each has a restricted Local User Account on the server.What is the drawback of using user instance in production environment?
Edit.Rather than considering the limitation in memory usage and database size that I know, let us consider the user instance only, why isn't it recommended?
I have usercontrol which has required field validation in it. I have 2 instances of this usercontrol in single web page . Now if I click button on first usercontrol the validation messages are fired for 2 user controls. But only the required fields of that user control has to be fired.
View 5 RepliesI've created a User Control (.ascx), which has a dropdown. When an item is selected, it uses some model classes to pull back a set of data which it then dynamically displays as a list of checkboxes in a panel control.
When I add one to the page, it works very well indeed.
However, when I add another I get this behaviour:
1. Select an item from the first dropdown, the checkboxes appear underneath ok.
2. Select an item from the second dropdown, the new lot of checkboxes appear ok, but the first lot disappear.
It's rather frustrating, they both have different IDs on the page, so they shouldn't interfere with each other should they? There is some Javascript that I've added but I use the Panel.ClientControlID to separate these out (I've already thought of that one).
I have a user control in my Master page and need to be able to Enable/Disable it from ANY page. How is this done? My user control has a few TextBox fields and a button. I was hoping to set a public property and simply Enable/Disable, but public properties seem to only work on the Master page code behind and not other pages.
View 4 RepliesI want to enable/disable controls of a asp.net page against a logged in user's permission. say 'admin' & 'hr' can change user's birth date text-box in a page but others will see the text-box as disabled.
so i wrote a function like this
[code]....
I have bounded my GridView to an ObjectDataSource. I have set a delete method for this ObjectDataSource. Now how can I delete my GridView's records with enable Deleting?
View 4 Repliesi am creating new database in my sql server 2000.But this database donot have any system storeprocedure. I am not able to create new store procedure in this database.
View 2 RepliesI am looking to enable/disable controls (TextBox, DropDownList, etc.) in a GridViews template column based on the users specific access level when the user clicks the edit button. I have tried the following two methods:
[Code]....
I want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?
View 1 RepliesI have following grid view and in it item template button2 now i want to make it enable only for some specific value say for session or some userid.so that only specific user can del the record.
<Columns>
<asp:CommandField ShowSelectButton="True" ItemStyle-Width="5" />
<asp:TemplateField HeaderText="del" ItemStyle-Height="100" ItemStyle-Width="50">
<ItemTemplate>
[Code]....
May i know how to create the control function in asp.net to control the values ?
Based on the DB table, it active is Y then enable values in dropdownlist , if N then disable the values.
I'm trying to allow logged user who are in department XYZ to perform some task for my third party App. I have two SQL tables named Users & UserList. The third party app (GoldMine) graps the USERNAME from the Users table and store it as UserID which I then referecnce SessionID. The UserList table has two columns (GM_UserName & Department) which I'm interested in. When a user login into the 3rd party app (GoldMine), i then compare the USERNAME (from Users table) to GM_UserName (from UserList table) and see whether GM_UserName is in = 'Dept XYZ'. Take a look at the SQL query below.
sqlDept = "SELECT USERNAME FROM Users LEFT JOIN UserList ON UserList.GM_UserName=Users.UserName WHERE UserList.Department ='Dept XYZ'"
I'm able to do this.
If Session("Userid") = "TestUser1" Or Session("UserID") = "TestUser2" Then Do this Else Do that End If
BUT unable to do this...
If user's Department = 'Department XYZ' Then
Do This
Else
Do that
End IF
I have a user control, that has an update panel and update progress control in it.
I use this user control in more than 1 location on the same page.... problem is, when ucA posts back, I see the update progress control for both ucA and ucB. I assume this is because it is a user control and the update panel and progress are named the same?
Either way - how do I make it so that the update progress only displays for the proper user control?
i am working in asp.net and csharp, we have 10 user, but certain user only need to put dataentry. how to enable and disable based on the user to access certain form ,like add, modify view options.
View 1 RepliesUsing ASP.Net and C#
Webpage Menus are Admin, HR, IT
I am using Login Page in my Website.
Condition
If the website is login by Admin User, Admin Menu only enable
If the website is login by HR User, HR menu only enable
How to make a code for the above condition.
This below code I am calling from asp.net page. it is giving error when I am executing UserObj.SetInfo().
My environemnt: asp .net 2003
My Objective: to enable windows user ids threw asp.net application with admin rights
---------------------------------------------------------------
Error Message : General access denied error
--------------------------------------------------------------
web.config file:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>[code]....
i want to use dataset , or any thing ... to display Sum * where user= user.identity.name(not use gridvew, or formview) because i have more then 100 columns . i m newbie. realy , 1 month, it not solve, sometime , i want to give up
View 3 RepliesI'm staring to learn T4 .I want to create a framework for my self that enable me to generate DAL and UI.Like Code generator softwares that maps Codes and User Interface from database .i don't have any question about generating data access layer.my challenge is to generate UI ( asp.net controls and HTML)
View 1 RepliesAs always with .net, there are many ways of achieving the same thing, so what is the easiest way of achieving the following?
<repeater>
<itemtemplate>
<DDL_control OnItemIndexChange="">
</itemtemplate>
</repeater>
In the repeater, there are a number of dropdownlist controls. Each one is hooked up to an event which triggers when changed. When one instance is changed I would like to disable all other instances of the DDL control.