C# - GetUsersInRole DataSource For DropDownList
Nov 22, 2010
I need to display in DropDownList a list of "Users" belonging a specific ROLE. This is my code:
// Find DropDownList
DropDownList myUserList = (DropDownList)uxInsertAuthorInput.FindControl("uxUserListSelector");
// Bind data to DropDownList
myUserList.DataSource = Roles.GetUsersInRole("CMS-AUTHOR");
myUserList.DataBind();
myUserList.DataTextField = "UserName";
My problem is when a visitor select an item in DropDownList. The actual value passed is the "UserName" and not the "UserId". I need to use the "UserId" value when a visitor select an item from DropDownList. How to do it?
View 2 Replies
Similar Messages:
Jan 27, 2011
I need populate an array with a list of Users that ARE NOT PRESENT in a specific Role and COUNT the result.At the moment I use this code, but I am not able to get the Users outside "CMS-ADMINISTRATOR " role.Any idea how to do it and better write the Count section?
string[] usersInRole;
usersInRole = Roles.GetUsersInRole("CMS-ADMINISTRATOR");
int c = usersInRole.Count();
View 3 Replies
Jan 13, 2010
I have an account called "admintest" which is "admin" as its role. I called the following line to delete the user with deleteAllRelatedData=false because I just want to mark the user as deleted (I may need to retrieve users' history later)
bool result = Membership.DeleteUser("admintest", false);
After that, I call the following line to get the user:
string[] users = Roles.GetUsersInRole("admin");
But I still get "admintest" in the users array.
View 1 Replies
Nov 15, 2010
i use 2 dropdownlist with 2 object data source first dropdownlist to display departments name using object datasource (field to display DeptName , value of field DeptID)
second dropdownlist to display Employee name but depend on departments (field to display EmpName , value of field EmpID)
how to display employee name in dropdownlist depend on departments name in the other dropdownlist
2 tables
1 table deprtments with column (DeptID , DeptName , DeptDescription)
2 table Employee with column (EmpID , DeptID , EmpName)
View 3 Replies
Oct 19, 2010
I have an SQL Data Source which selects all rows of a table. I need to populate a dropdownlist with a certain field ('percentage') of all the rows, and when one is clicked to make the 'value' the rows 'id' field. Is there a simple way of doing this?
View 1 Replies
Jun 11, 2010
how to bind data to dropdownlist in asp.net ....
View 10 Replies
Dec 29, 2010
I have a DropDownList. I need visualize in it a SINGLE value (ListItem) the current Logged in User, like
<asp:ListItem>Joe</asp:ListItem>
Here my wrong code, if the UserName is "Joe", the DropDownList visualize for every single letter an ListItem: Example:
<asp:ListItem>J</asp:ListItem>
<asp:ListItem>o</asp:ListItem>
<asp:ListItem>e</asp:ListItem>
This is my code:
<asp:DropDownList ID="uxUserListSelector" runat="server"></asp:DropDownList>
MembershipUser myCurrentUser = Membership.GetUser();
myUserList.DataSource = myCurrentUser.UserName;
myUserList.DataBind();
View 1 Replies
Jan 10, 2010
When i am trying to add a data source to a dropdownlist control in asp.net using VWD, it doesnt allow me to to do that says the extension doesnt match.
I have msofficce 2007 and the msaccess file gets saved as accdb .
View 1 Replies
Jun 22, 2010
[Code]....
DropDownList and PageMethods?
View 3 Replies
Nov 17, 2010
i extended a dropdownlist on a textbox. now how to set the datasource of this textbox.im tryingtextbox1_dropdownextender.
View 2 Replies
Dec 2, 2010
How to retrieve selected value of dropdownlist filled from datasource in asp.net?
Dim str1 As String = "SELECT UserName FROM Login WHERE Category = 'Property'"
Dim cmd1 As New SqlCommand(str1, conn)
Dim myreader1 As SqlDataReader
conn.Open()
myreader1 = cmd1.ExecuteReader()
DDLCat.DataSource = myreader1
DDLCat.DataValueField = "UserName"
DDLCat.DataTextField = myreader1.ToString()
DDLCat.DataBind()
conn.Close()
View 1 Replies
Jan 5, 2010
I'm using a SP to fill the drop down list and when I look at the values in the drop down list the first row of the dataset is missing.Here's the code I'm using, I've left out the database connection info and the link to the SP
StaffListRS = cmdStaff.ExecuteReader()
If StaffListRS.Read() Then
ddlStaffList.Datasource = StaffListRS
ddlStaffList.DataTextField = "StaffName"
ddlStaffList.DataValueField = "NewStaffID"
ddlStaffList.DataBind()
ddlStaffList.Items.Insert(0, New ListItem("All", 0)
If
View 3 Replies
Mar 6, 2010
Trying to add another 2nd dropdownlist to Query String... Below This Query String works Perfectly:
Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' ORDER BY {3}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text, SetSorting())
I've tried to add a 2nd DDLSubCategory.SelectedItem.Text - But its throwing and error message.
Exception of type System.StackOverflowException was thrown.
Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' AND NASubCategory = '{3}' ORDER BY {4}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text,
DDLSubCategory.SelectedItem.Text, SetSorting())
Can Someone take a look I'm not sure how to write (add) 2nd DropdownList (DDLSubCategory.SelectedItem.Text)
View 6 Replies
Mar 31, 2010
I just like to know how to pass a parameter to the datasource of my dllItemCodeFooter and dllItemCodeEdit Drowndownlist which calls my getItemCodeList(decimal categoryID) method in the code behind. The value of the parameter will be seletectedValue of the first dropdownlist(ddlCategoryFooter or ddlCategoryEdit).I know it could be done in code behind, but i prefer to bind my datasource in asp page. I want to achieve something like this
DataSource='<%# getItemCodeList(ddlCategoryEdit.Seletected)%>'
Below is the code for my Gridview
[Code]....
View 1 Replies
Sep 8, 2010
My application includes a gridview control with and Edit mode which allows users to do selections using cascading dropdownlist. My code is based on tutorial by Brian Orrell (link below). I am able to statically populate the dropdownlist but in my case I need to populate it dynamically based on a previous selection of a dropdownlist, I would like to do it programatically so I can manipulate data.
[URL]
View 3 Replies
Jan 19, 2010
I'm having trouble linking a form view I have on a web page with a drop down list on the same page. Basically, what I need to happen is whenever a new selection is chosen from the drop down list, the details in the form view should also change to represent that selection's criteria.
I have my drop down list connected to SQLDataSource1 and my form view to SQLDataSource2, and these are populating as expected, it's just the problem lies when changing the selection in the drop down list - the form view doesn't follow what is selected.
does anything have to be added in the properties options of either the data source controls or the form view? For example, in the "Events" section, there is a "DataBinding" and "DataBound" selection item that can be used - should anything be entered in this to connect the two?
PS - Here is the code I have in the back end of the page:
[Code]....
View 2 Replies
Jan 12, 2011
I want to sort the dropdownlist by date, but i cant figure out how.
ddate.DataSource = myTable
ddate.DataTextField = "ddate7"
ddate.DataValueField = "ddate7"
ddate.DataBind()
View 2 Replies
Feb 25, 2010
i have a DAL function to get the records from DB. it will return a dataset. now i want to use linq from dataset and bind the dropdownlist, gridview data comtrols. pls any one give me a sample. also i want to know whether we can use distinct, fileter in linq.
View 4 Replies
Mar 5, 2010
I'm using a DropDownList with a data source which successfully populates the list. However, I want one of the items to be selected, namely the one where the value matches the path and query of the current request.
ddlTopics.DataSource = pdc;
ddlTopics.DataBind();
foreach (ListItem item in ddlTopics.Items)
{
item.Selected = item.Value.Equals(this.Page.Request.Url.PathAndQuery);
}
Using the debugger in Visual Studio 2008 reveals that item.Selected becomes true exactly once in the loop, but the rendered select has no option that is selected.
View 5 Replies
Jun 14, 2010
I have a form that has n dropdownlists, and the form has gotten so big that it now weights over 1.2MB...I was wondering, is it possible to load the datasource items once in the browser and have all related dropdownlist use that single datasource to conserve bandwidth?Something like, load datasource into div, and on page_load have all dropdownlist load from that div...
View 1 Replies
Apr 19, 2012
I have 5 dropdown list (sector-country-year-project code-project title) so what i need is when i select specific sector for example education , the rest of the label should show me the only data related to the sector education in dropdown list. the same with other if i select year 2011 should show me in other dropdown list just the data related to year 2011.
View 1 Replies
Feb 22, 2010
Trying to Add a Dropdownlist Selection to a Query String. When I use this :
[Code]....
View 5 Replies
Feb 25, 2010
if I have three Dropdownlist A, B, C, how can I write a select statement to get data from sql server based on the dropdownlist selected.e.g. if user select dropdownlist A, select * from table where A = dropdownlist A but if user select dropdownlist A and C, then select statment is "select * from table where A = dropdownlist A and B = dropdownlist B or if selected A, B, C.......how can I settle so many choice.
View 2 Replies
Nov 15, 2010
I have a Formview InsertTemplate a dropdownlist with datasource1 and I want onclick of an imagecontrol the dropdownlist will display another set of data from datasource2 instead.
Protected Sub ImageOnClick1(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs)
Dim dropdownlist1 As DropDownList = CType(FormView1.FindControl("dropdownlist1"), DropDownList)
[code]...
View 3 Replies
Jun 10, 2010
i think i can't see the forrest for the trees.......there HAS to be a simple way to do this. so i created a web page and on that page i have two dropdown lists. the first is STATE and the second is COUNTY. the STATE is a static list. but the COUNTY is generated whenever the STATE changes. now....when i set up the COUNTY dropdown list, it prompted me for a datasource. i have a store procedure which takes the 2-letter STATE code and returns all the counties for that state. so i set up the datasource for the COUNTY drop down list by just following the prompts from visual studio. i gave it a default state of Alabama (AL). and all is fine. so here's my question: how can i reload the datasource and subsequently the COUNTY dropdown list? i see no way to access the datasource that the environment generated for me.
well.....i thought.......i'll just do it the old fashioned way and set up a command.......connectionstring.......and sql statement and load the results into a datareader (do i REALLY have to do all that?)
but it still doesn't work. what's the simplest way for me to just re-fire my stored procedure and pass it the STATE parameter and reload the datasource and dropdown list?
View 3 Replies
