I'm trying to auto-populate a listbox of zip codes from a database table state_zipcode_plans based on the state a user selects from the previous listbox. I'm getting the error: Must declare the scalar variable @state_code.
I need to populate a listbox with queries from 2 sql tables, but I can only see how to populate it with 1 datasource.
Do I need to do some hand coding? If so, where should I put it?
I'd also like to add some text items to the listbox so I could say populate the listbox with a query, plus an "other" option, so that if "other" is selected, a textbox will appear that will let the user specify a new item.
IdApplication ApplicationDesc Permissions 1 User Add 1 User Delete 1 User Update 2 Role Add 2 Role Delete 3 User2 Modify 3 User2 Change
How can i Bind like in nested repeater control
In my Nested repeater control bound i need to Bind the Values like this Formate According Groupwise
User Add Update Role Add Delete User2 Modify Change
In the nested repeater control i taken a label in Header Template i need to bind 3 different values Application Desc once User, Role, User2 and in Item Template i had binded the <%# Eval("Application Desc")%> but i am getting like this all permissions in 1 line
I'm creating a user control that enables users to search AD and add the selected names to a list (which is used to send mail lateron).
The problem is that the search results end up in the Listbox but all as the string "System.DirectoryServices.ResultPropertyValueCollection" in stead of the actual values.
I have a listbox controll and i want to bind it with an SqlDataSource.SqlDataSource must be declared in the code behind but i don't know where declare it(page init,page load...)and how to add sql parameter dynamically (parameters are the selected values of listbox, so they are multiple).
A ListBox is being filled from the database, from a SQLDataSource. Im setting the parameters in its _Selecting event. Except when it is done getting its new Data, the ListBox isn't updated with this new data. Eventhough i rebind my ListBox to the DataSource.
I am inserting mortgage loan scenarios in via GridView table. Let's say $100K loan with FICO score 700 in state of MN.
Sometimes I want to apply the same scenario to multiple states rather than Inserting one row at a time. I figured a Listbox with SelectionMode="Multiple" option would be to way to go.
After a few hours of searching I couldn't find a solution to this issue so I figured I'd try a post. I have stored procedure that queries 3 tables and retuns 1 set of results. When I execute the sproc using the following code db.GET_TRAININGS(userID).GroupBy(s=>s.COURSE_TITLE); I get back an IGrouping container where the course title is the key and contains 2 GET_TRAINING_RESULT elements. Then I bind using rptCourses.DataSource=trainings; then databind(),etc.What I'm trying to do is have the parent repeater show the course titles and the nested repeater show the modules for that course for the particular logged in user. Basically trying to turn a flat piece of data into heirchical data.The stored procedure returns the following SQL Columns Course_Title, Module_Path, Module_Name,Sequence. The sproc code is below:
I am trying to create a multi column listbox by combining fields in Linq select statement, as Let Name = Last + First. The problem is how to pad the Last column with spaces as you would in SQL using REPLICATE so when I bind the listbox to the data, it looks like two columns.
I am designing a program that will let me enter the name of an item to swap and adds the swap to an array list when a button Add is pressed. Once the item is added to the array list a Sub Procedure should be called which displays the contents of the array list in a list box.
The system will also allow me to remove items from the array list using a Remove button
followed by updating array list.
I have done some part which puts item into the listbox1 which i named lstSwapList.I would need some assistance on the Sub Procedure to display the Value or Description on the other listbox2 which i have also named lstContent,if a value is selected from the listbox1.
I would also want to know how to update the Listbox content,However i hv added a sample of the way i guess it may be.
Any complete solution from anybody on the Sub Procedure and the Update Swap procedure will be greately appreciated.
The script below is what i have done so far.
Partial Class _Default Inherits System.Web.UI.Page Protected Sub lstContent_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles lstContent.SelectedIndexChanged End Sub Protected Sub lstSwapList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles lstSwapList.SelectedIndexChanged End Sub Protected Sub btnAddSwap_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAddSwap.Click Dim SwapValue As String = "Sixty Pounds" Dim Counter As Integer = 8 Dim SwapN0 As Integer lstSwapList.Items.Add(SwapValue) lstSwapList.Items.Add(Counter) lstSwapList.Items.Add(New ListItem("300", "1")) lstSwapList.Items.Add(New ListItem("ASP.Net", "2")) lstSwapList.Items.Add(New ListItem("Programming", "3")) SwapN0 = lstSwapList.SelectedValue For Counter = 0 To -1 SwapN0 = lstContent.Items.Count Next End Sub Protected Sub btnDeleteSwap_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDeleteSwap.Click lstSwapList.Items.Remove(lstSwapList.SelectedValue) End Sub Protected Sub btnUpdateSwap_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpdateSwap.Click End Sub End Class
======================================= Sub UpdateSwap(ByVal valueA As String, ByVal ValueBAs String, ByVal ValueC As Integer, ByVal ValueD As Date)
I can select IQueryable<object-type> data fine from a data repository class and push it into a list type MVC view, but how do I do this and group that data - I don't seem to be able to find any examples on this.
I have two list boxes, one has a list of available users (about 1500 items) and the other is blank. There is a button to add the seleted items from the first list box to the second one. Both of these listboxes are within an update panel and for some reason it takes over 20 seconds for the items to show up in the second listbox.
Is this normal? Is there an alternate, faster way of doing this?
how I can read the selected field from the listbox?I have MSAccess table attached to the app.I can get to the properties, but I don't know which property gets me the data of the specific field.In VB it would be "listbox1.Column(x)", where 'x' represents the column number in the listbox1.I am using Microsoft Visual Web Developer 2010 Express
All i did is added an existing webform from vs 2003 project to vs 2008. with Listbox1 control this error is appearing. value of type system.web.ui.webcontrols.listbox cannot be converted to "myprojectname.listbox"
i also have the control defined on the top: Protected WithEvents Listbox1 As System.Web.UI.WebControls.ListBox I have converted lot of pages which were used in vs 2003 to vs 2008 without any problem, also tried to right click teh webform and go to code gen file , but the file is not coming up.
I have a listbox which populated from using a datatable. I have a Add button in my page. On clicking the add button I want to insert a blank row in the listbox. This can be done easily by
ListBox_Admin.Items.Add("");
after this is done I want to select this item as in setfocus on this item.How do I do this.
I have been trying to figure out how to use <asp:requiredfieldvalidator> with ValidationExpression but am having a difficult time understanding the syntax of ValidationExpression. I'd like to make sure one textbox's number (1-12) is equal to or higher than the other textbox's (1-12) number. How is this accomplished and what's the syntax of ValidationExpression (hopefully I'm stating the question correctly).
I'm moving itmes from one ASP.NET ListBox control to another ListBox control from client-side. It works on the client-side but when I tried to count items in destination ListBox on the server-side, it's always nothing. Below, is the jQuery code used to add/remove items from ListBox control.
[Code].....
I know that we can add/remove items from ListBox from server-side. But I'd like to get it done from client-side. Why there isn't anything in the destination ListBox when counting the items from the code-behind, eventhough the items are added from the client-side already.
We say that "GroupBy" and "OrderBy" methods from LINQ as Extension Methods.Then how about "variable.ToString()" and "string.Split()" menthods. Are these Extension methods.
I have a detailsview which is used to input data into an SQL database. Some of the fields contain drop down menus which are populated from the database.
I also have a form that allows the user to select mutiple values from a listbox (populated from an sql database) by moving the required items from one list box containing all the available items into a second one containing the selected items. There is also a text box which is used to filter on the available items. When this is passed through to a stored procedure to be put into the database, it is passed as a comma delimited string containing all the selected values.
This works fine on a separate form, however I would like to include it in one of the fields of the detailsview. This creates a BC30451: Name 'ListBox1' is not declared error. I have looked for hours on the internet to try and resolve this but cannot find what I need for how to declare the list for use within the detailsview.
Here is the code for both the working multiselect form and the code for when I have tried to integrate it into the detailsview:
I want to select the multiple items in the listbox.....for eg in my listbox there are five itemsapple,pear,lotus,red,blue.on button click i want to select two items from the listbox.