I have a requrement to create multicolumn dropdown list.
It must look exactly like the one given below
i ran one query to imoplement this functionality in SQL Server Stored Procedure
[code]....
The seperator bar is not in uniform place,so it is not looking like a column seperation
I need to display data like below in web part and in place of cross red image there will be plus and minus image for expanding and collapsing data.
Account Reconciliations
Completed Reconciliations
211
Incomplete Reconciliations
45
Overdue Reconciliations
10
Completed on Time
12
Tracking Reconciliation Items
12
My database has 4 colums;
TraditionalID-------------TraditionalName------------Singles-----------Suppers
Singles and suppers are money fields for the price of same item. A bit like the price of a Small, Medium or Large item. What I would like to do is display the 'Singles' price and 'Suppers' price in seperate listitems so the user can choose 1 of them.
GridView:
Traditional Name__________Size
Chicken-------------------[DROPDOWNLIST]
DropDownList:
Price of Single is: £1.50
Price of Supper is: £2.50
My page loads up with the correct items in TraditionalName colum but the DropDownList is completely empty. I'm aware I don't have anything in for DataValueField and DataTextField but I have tried putting things in these attributes, like Suppers and Singles, but nothing works, so I have taken them out below.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="TraditionalID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="TraditionalID" HeaderText="TraditionalID" InsertVisible="False" ReadOnly="True" SortExpression="TraditionalID" Visible="False" />
<asp:BoundField DataField="TraditionalName" HeaderText="Meal" SortExpression="TraditionalName" />
<asp:templateField HeaderText="Size">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2">
</asp:DropDownList>
<asp:HiddenField ID="RowTraditionalName" runat="server" Visible="false" Value='<%# Eval("TraditionalName") %>' />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:The CodfatherConnectionString %>"
SelectCommand="SELECT Suppers AS Suppers, Singles AS Singles FROM [Traditional] WHERE TraditionalName = @TraditionalName">
<SelectParameters>
ControlParameter Name="TraditionalName" Type="String" ControlID="RowTraditionalName" PropertyName="Value" />
</SelectParameters>
</asp:SqlDataSource>
</ItemTemplate>
</asp:templateField>
</Columns>
</asp:GridView>
How do i Limit the dropdown box.OR MultiColumn display in dropdown box
View 1 RepliesHow to show in dropdownlist text arabic and english in asp.net ....
View 1 RepliesHow to bind two database field in single listbox in display field.
Is it possible ??
If yes then how can we implement it?
I need to know how to populate a multicolumn ASP listbox on a Web
form using excel 2003 data . ( 2 columns in the Listbox )
When the user makes a selection from the Web listbox I want to
populate part of the web form, but I want to post the full form data to
another spreadsheet. ( NOT ACCESS)
protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrict();
}
[Code]......
here when i click on ALL item from ddlzone1 Â it just "ALL" item in ddldistrict
i want when i select "ALL" item from ddlzone1 in ddldistrict14 show all data from database
I have two pages manager and user both have drop downs asÂ
Week, Months and Years.
User have to enter some data week wise for each months and Manager have to approve that.
To Approve manager select months and week from dropdown on his own page and then navigate to User page.
How does I should bind the drop down so that if manager select 1st week from it's page and goes to view link of user then in drop down of user selected value shold be the same as selected by Manager on his own page.
I hv a filed in db having 60 values. I want them to be displayed as checkbox values on my UI.but i want those checkboxes as 15 values in 1 column.15 in 2nd col.15 in 3rd col.and last 15 in 4th coln. how to do it?
View 3 RepliesI'm looking for a free ASP.NET 2.0 ListBox control that supports display of items in two columns. It also needs to support selecting multiple items.
I really prefer not to have to use a monospaced font and mess with formatting my ListBox items into columns.
Using dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 RepliesI want to create a multicolumn treeview control.I searched for it and found many of them but none of them free. So decided to build one of my own.Need guuidance for proceeding.
View 2 Repliesi 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)
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
I would like to store some business flags (like: isFavorite, isOnLive etc.) per an html table row that won't be visible to user.
In practice, I have a simple ADO.Net DataTable on my code-behind which is used as a data-source for a asp.Net GridView control.
This table contains some business flags on its 0th, 1st, 2nd columns.
I need to store those columns on the rendered HTML of the grid-view -so that I can reach them via JavaScript- but I do not want them to be visible.
i'm binding data to ddl from database.i'm selecting one column from database table to bind.In that column there may be items with same name.but when selecting in ddl there must be no same values.
View 4 RepliesHow to swap ddl's selected value on buton click.E.g User has Selected One from ddl1 and three from ddl2 then when the user clicks the Button the values should be swapped.
User Selected
DD1 DD2
One Three
After Swap button click
 DD1 DD2
Three One
<asp:DropDownList ID="ddl1" runat="server">
<asp:ListItem>One</asp:ListItem>
<asp:ListItem>Two</asp:ListItem>
<asp:ListItem>Three</asp:ListItem>
</asp:DropDownList>
[code]...
I see that dropdownlist has an "items" property to get the list of displayed items for a dropdown, but it doesn't seem to have an equivalent property for getting the "values" associated with the items. For example, I may have a dropdown that displays "High", "Medium" and "Low", but returns values of "H", "M", "L". How can I easily get that list of HML?
View 5 RepliesI have a dropdownlist which display the price of products which is retrive from database, how do i mulitply if the user entered the quantity in the textbox. I keep getting error input string was not in a correct format.
Here is my aspx code:
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Order.aspx.cs" Inherits="Order" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">[code]......
I have a problem I have been googling the entire day and still have no soloution. I have a detailsview with 2 dropdownlists. Fisrt one is ddlCaregory. Second is ddlSubCategory. The value is passed from the first ddl to display the SubCategory linked to ddlCategory. Both ddlCategory and ddlSubCategory are Templatefields. This is also in VB.
The Details view has a sqlDataSource (sdsApplicants), ddlCategory has a Datasource (sdsCategory) and ddlSubCategory (sdsSubCategory). ddlCategories lists the data returned from sds Categories and save any changes to sdsApplicants. I can get ddlSubCat to display the correct SubCatagory bases on ddlcategory sesection but as soon as I try bind it to sdsApplicants I get the following error
'ddlSubCategory' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
I have hard coded and added items to dropdownlist ie teamsize as 1,2,3 like that.When i load this dropdownlist for edit/update i get duplicate values like this
1
1
2
3
4...
How do i eliminate this duplicate values?
Let's say I have DropDownList ddlRooms bound to the datasource which returns list of available rooms from table tblRooms. On the other hand I have users, and their info is stored in table tblUsers. Using FormView frmUsers can be inserted, edited and updated... frmUsers is be bound to separate datasource. To each user, I would ilke to assign a room, so the value of txtUserRoom will be populated based on the selected value from ddlRooms. How can i pass the selected value of ddlRooms to txtUserRoom while keeping txtUserRoom stil bound to user datasource? Do I need two separate fileds or can i just put value of ddlRooms into datasource user?
View 3 RepliesI have a dropdownlist which gets the data from the oracle database, the values that contains quotes example "Apple's" or "Website's" or not getting seelcted from the list except these values remaining values have no issues.
View 3 Replies my c# web application populating dropdowns with datas at run time... i.e my web form contains 3 dropdowns and one gridview.. dropdown1 populate with 'pgmtitle' which is fetch from database,when user select one item-pgmtitle from dropdown1,participants(BadgeNo,Name)
of that pgm will be populated in gridview. when user click on the participant badgeno,dropdownlist3 will poputated with recieving officers name.. wen user select one of the recieving officer from dropdown3,his designation is dispalyed in a textbox,and dropdon2
will populated with feedback sentdate... this is my requirement... and my pblm is, when i choose another pgmtilte(say pgmtilte2) from dropdownlist1,previous value associated with(pgmtilte1) appended with dropdown2 and dropdown3.. here is my HTML code:-
[Code]....