After I execute a data reader and put the readed string from the database in my dropdownlistbox, I cannot add another item in it.Here's my code:
con.Open()
Dim com As New OleDbCommand("Select Status from Table where Id = 'somevalue' ", con)
Dim dr As OleDbDataReader
[code]...
I have a dropdown which i have binded code behind as:
protected void PriorityType()
{
DPriority.Items.Add(new ListItem("--Select--", "0"));
DPriority.Items.Add(new ListItem("High", "1"));
DPriority.Items.Add(new ListItem("Medium", "2"));
DPriority.Items.Add(new ListItem("Low", "3"));
}
It shows the items in gridview correctly but when i insert in database as DPriority.SelectedValue . it does not save the text but the index
Like if i choose High in database it saves as 1 but it should save as text not index.
I have a listview which has a complicated Item template that contains a repeater, an objectdatasource and some other controls. On the first run I am only showing 10 Items of the listview. The user has an option to show 10 more ListView Items. If user clicks on show older items; the listview shall add another 10 items. how to go around this since my list view already has a datasource and I don't want to rebind the whole listview all over again. Instead; I just want to add another 10 items.
View 7 RepliesI have some dropdown list boxes that I need to fill with data from a database but I also need the first option to be "Show All"... So I need to combine using a datasource and manually adding an item to the top of the list. I have tried two different ways with no luck:
1. with the appendDataboundItems = true, on aspx page, and below code in codebehind:
//lstClass.Items.Clear();
I am using the cascading dropdownlist controls from the Ajax toolkit. I have everything working perfectly and all of my select changes work. I have 3 related select boxes that all work great for single item select. What I need is for my last dropdownlist to allow for the selection of multiple items. I have tried adding the 'multiple' attribute to the final dropdown list and it allows the selection of multiple items but I cannot get the items when I post back, just a single item.
View 7 RepliesI have a list item collection. How to add this list item collection to a datatable.
The list item collection has the following fields:
Student Name, Maths Mark
John 20
Mac 30
John 35
I want to create a html table from the data table, which is grouped on the Student Name field.
Looping Through Checkbox List and adding selected items to MS SQL DatabaseI don't want to store it using comma deliminator.I will need to do a search on analyze which users have what music in common.The image above is from a tbl_lookup_music table I created. MusicID, MusicNow how should I build the logicIF we have a user that has a tbl_profile table. And listens to many different types of music. How should We store the data.------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_lookup_music]( [MusicID] [int] IDENTITY(1,1) NOT NULL, [Music] [nvarchar](64) NOT NULL, ---- Type of music. CONSTRAINT [PK_tbl_lookup_music] PRIMARY KEY CLUSTERED ( [MusicID] ASC )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY----------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_Profile_Music]( [ProfileMusicID] [int] IDENTITY(1,1) NOT NULL, [ProfileID] [int] NOT NULL, [MusicID] [int] NOT NULL,PRIMARY KEY CLUSTERED ( [ProfileMusicID] ASC)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOHow should I setup this table.
View 4 RepliesDoes anyone know how to do this so when I select something the 1st dropdown and the 2nd one becomes visible and populates list from a Select statement. I really need help on how to do in an aspx and not on the code behind page.
View 12 RepliesI have a repeater control:
<asp:Repeater ID="rep" DataSourceID="XMLDSCompare" runat="server">
<ItemTemplate>
<h4><%# XPath("title")%></h4>
</ItemTemplate>
</asp:Repeater>
Now if its the first item in the total resultset, I want to add <div> to ItemTemplate control, if its the 2nd item, I want to add </div>
So output would be (not including table tags generated by repeater control):
<div>
title 1
title 2
</div>
<div>
title 3
title 4
</div>
<div>
title 5
title 6
</div>
How would I do this in the ItemDataBound event of repeater control?
I have a drop down list control populated with items and some code to take the currently selected item value. The problem is I only get the value of the first item in the list regardless of what item is actually selected. Here is my code to populate the drop down:
protected void displayCreateCategories()
{
StoreDataContext db = new StoreDataContext();
var a = from c in db.Categories
orderby c.Name
select new{catName= c.Name,
catId=c.CategoryID};
ddlCategory.DataSource = a;
ddlCategory.DataTextField = "catName";
ddlCategory.DataValueField = "catId";
ddlCategory.DataBind();
}
To get the value of the currently selected item which in my case is always of type integer I do label1.text=Convert.toInt32(ddlCategory.SelectedValue); I get the selected value, but it is always for the 1st item in the list. I'm pulling my hair out over this.
How to add Items in the Dropdown at the Runtime..?
View 2 RepliesI am getting this error: "Cannot have multiple Items Selected in Dropdown", when I Edit the data.
I want to loop thru dropdown list and check the individual list item text using C#, let me know what is the best way to do this?
View 4 RepliesI have a situation where some dropdown listboxes contain some items, then there's a separator line, and then there are more items. The ones above the separator line reflect the "commonly used items". To better highlight these I was using code like this to individually color those specfic items:
foreach (ListItem item in ddList.Items)
{
if (item.Value == "-1")
unAssigned = true;
if (!unAssigned)
item.Attributes.Add("style", "color:#5558ff");
}
This code works fine EXCEPT that once a PostBack occurs then the highlighting disappears. The items in the dropdown listbox remain (without repopulation) but not the highlighting.
I'm curious why this is happening and whether there's a way for the highlighting to "stick" short of calling this code from the Page_Load event handler every Postback?
how to access related columns in a dropdown list? In the example below I have a dropdown which is bound to a list of countries, I know how to access the text & value fields but how would I access data such as "Region"? I know I could do this by spinning through the list until CountryCode on the lsit and selected item match but wondered if there was a better way.
[Code]....
i have over 100 items all loaded in a dropdown list. They all are assigned a value between 1-10 which represent 10 categories. When certain buttons are clicked, i want the dropdown list to display only items with a value "1" or "2", etc.
View 3 Repliesi have a dropdownlist for which i have items like red,blue,yellow,green...etc but these items default static color will be black for all items,
but my requirement is to Red as red color Blue as blue color Green as green color
[Code]....
I use telerik radgrid, where i add dropdown column for add and edit new grid row.When i update grid row item the dropdown value is not disply in dropdown list, but disply in dropdown first data.
View 1 RepliesI am using following code for filling dropdown
[Code]....
Till here it is working properly, but when I add following line after loop, it added another name. Actually I want to show username selected for logged in username i.e. strFullName
[Code]....
i have used one drop down list box...in that ....whn i m running web applicaiton i need to stick the value which i m selected for the movement upto i select the next choice. it is always going to the first value always. i have 40 items in my drop down. whn i select the 5TH item after selecting 5th item it going to first item.
View 1 RepliesI am using database table as datasource for my dropdownlist. I want to add an extra item in my dropdownlist for example "select country".
how can i do that.. currently my code is:
dropdownlist1.datasource=dt;
dropdownlist1.datavaluefield="country_id";
dropdownlist1.datatextfield="country_name";
dt is a datatable , "country_id" & "country_name" are columns
I have a checkboxlist which is being dynamically populated. Code is below.
chklbCourses.DataSource = dt; // datatable returning
CourseName,CourseID and price
chklbCourses.DataTextField = "CourseName";
chklbCourses.DataValueField = "CourseID";
chklbCourses.DataBind();
Now I want to add another item to checkboxlist which is price of each item that is coming from database. How can I attach third value "Price" to each item of checkboxlist. Do I need to add attribute or what to each item ?
Is it possible to display the items in a dropdown list not by the order of insertion?
i want to display the orders alphabetically.
Is there a way that we can change the color (which is defaulted to blue) when the items in the list box are selected? If so can you provide me a sample for it?
View 1 RepliesI have a below control in my asp.net page (3.5 framework).
<asp:ListBox ID="OptionSelector" runat="server" SelectionMode="Multiple"
SkinID="CPList" Rows="6"></asp:ListBox>
There are 25 items in the list. I have selected one item at the time of project creation. But If I edit the project then the list box is showing more selected items instead of one item in the details page.