have a page that has a results gridview where I have all rows with a chekbox. when I click on the checkbox I try to create an excel filethis is method content:
DataTable MyData = new DataTable(); //recorrido sobre los elementos seleccionados6 foreach (GridViewRow row in gvwDbf.Rows)
[code]...
The problem is that excel file is totally empty. When I trace on the error I find that (item on bold above) dt datable has current record as I expected but Mydata table has nothing inside. shouldn't I use import statement? How can I get the row copied? I intend to have a full table made by every record coming from parameters of each query which is performed inside a for each sentence
Cannot have multiple items selected in a DropDownList.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Cannot have multiple items selected in a DropDownList.
Source Error: [Code]....
Line 85: function openPopup2(did) Line 86: { Line 87: var hdnClm1 = document.getElementById('<%=hdnCliamid.ClientID%>').value; Line 88: window.location="Form.aspx?DeleteRSPid=" + did + "&Editid="+ hdnClm1; Line 89: }
[HttpException (0x80004005): Cannot have multiple items selected in a DropDownList.] System.Web.UI.WebControls.DropDownList.VerifyMultiSelect() +106 System.Web.UI.WebControls.ListControl.RenderContents(HtmlTextWriter writer) +124
I'm designing a web page with two dropdownlists, one for the Make of a car, the other for the Model, both bound to a database with separate SQLDataSources, and using a distinct statement. I add "All" at the top of both by setting appendDataBoundItems = true and adding items named all. Then when I fill the Make with a querystring all the model items get added twice (but only the databound items).Here's my code:
<asp:DropDownList ID="DropDownMake" runat="server" DataSourceID="SqlMakes" DataTextField="Make" DataValueField="Make" AppendDataBoundItems="True" EnableViewState="False" AutoPostBack="True"> <asp:ListItem Selected="True" Value="All">All</asp:ListItem> </asp:DropDownList> <asp:DropDownList ID="DropDownModel" runat="server" AppendDataBoundItems="True" AutoPostBack="True" DataSourceID="SqlModels" DataTextField="Model" DataValueField="Model" EnableViewState="False"> <asp:ListItem>All</asp:ListItem> </asp:DropDownList> <asp:SqlDataSource ID="SqlMakes" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT DISTINCT [Make] FROM [Parts]"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlModels" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT DISTINCT [Model] FROM [Parts] WHERE ([Make] = @Make)"> <SelectParameters> <asp:ControlParameter ControlID="DropDownMake" Name="Make" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> 'And in the VB file: Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init DropDownMake.SelectedValue = Request.QueryString("Make") DropDownModel.SelectedValue = Request.QueryString("Model") End Sub
If I remove the line "DropDownMake.SelectedValue = Request.QueryString("Make")" it doesnt produce duplicates anymore. What is going on?? I swear I've spent more time developing entire iphone app.
I have a dropdownlist that contains items from a database. The set of items are unlikely to ever change. At the moment, whenever a user tries to access the View with the dropdownlist, the code retrieves the data each time from the DB. I would like to change this so that the set of items are cached and load on the application start only.
Could somebody indicate the best mechanism for this scenario? I have read up on Enterprise library which is my current preference, though any alternatives (with reasons) would be welcome.
I am trying to add the value from a textbox which is also in the formview into the dropdownlist as a list item. I currently have this code for it: Protected Sub Formview1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.PreRender Dim dropdown As DropDownList Dim listvalue As TextBox dropdown = FormView1.FindControl("dropdownlist5") listvalue = FormView1.FindControl("textbox1") dropdown.Items.Add(New ListItem(listvalue.Text, listvalue.Text)) End Sub
This code works and adds the new item to the dropdownlist if I have no SelectedValue set for my dropdownlist. However when I set the selectedValue I get the error message:
"'DropDownList5' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value"
This is the bit I dont understand because the value does now exist in the list of items as it was added in from the textbox value. Does it try to do the selectedValue before adding my list item? If so how can I add the list item first, or do I need to set the selectedValue in the code after adding the list item?
i have a database table with lot of records > 17000what is the most efficient way to let user to choose between one of the records- 1 dropdownlist with all the 17000 record ?- 1 textbox with autocomplete and a webservice that return the list of the records ?
On the home page as I on work, I have a dropdown list which act as a menu. But in Internet Explorer can not figure out how to display all text in my dropdown list How it looks in Internet Explorer
How it looks in firefox, chrome and opera Do you know how to do so that Internet Explorer also displays all the text in my dropdown list like in firefox and the other
I have a cascading dropdown list on my page. The first dropdown contains a list of events. The second dropdown contains a list of attendees. When an event is selected, an AJAX call is made to get the list of attendees for that event, and populate the second dropdown.
My problem is that for the attendees dropdown, I want the user to be redirected to a URL on the SelectedIndexChanged event, with the selected value in the query string. But on the SelectedIndexChanged event, all the items in the second dropdown are reset. Here's my code:
Using MVC2, I want to know how you add the options of a dropdownlist from a database. I have several lookup lists so I will need to do this many times. I'm stuck on part 5 of the MusicStore (which is using MVC3) at this part
[Code]....
Alternatively if someone could recommend an MVC2 tutorial which covers drop lists.
I have dropdownlists in Gridview. I need to dinamicly change content of dropdown on client with javascript. Ok, I know to do that. But the problem is when I send data to server changes in dropdownlist does not see. On server I have old items. How can I change items in dropdown on client with javascript and than see that items on sever when postback data?
On adding items in it ,shows an error: "Dropdownlist does not allow multiple selection."But when i tries to print the selected item it shows null exception.
I'm using a text book to teach myself ASP.NET 3.5. I'm using Visual Web Developer 2008 express to create my pages. At this point in my text, the author has me drag a DropDownList control to the Web page and then tells me to go to the Properies window and look at the Items property. I don't see an Items property. I've doublechecked that I'm on my DropDownList control, but I see no Items property. Is this a bug in VWD, an error in the book, or just plain old User error?
I'd be willing to hard-code the property in the source window, but I don't know the syntax. I tried items="Vanilla, Chocolate" but nothing appears in the list when I view the screen.
I would like to highlight (bold) and disable certain items in the dropdownlist for selection.
My dropdownlist is fed from a SQL table of countries e.g.
Europe -UK -FR -DE -AU
I need to heading "Europe" to be not selectable? the database has a column (selectable = 0) for those heading and I need to make them not selectable on the client side.
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?
I have two DropDownLists; DropDownListStart displays the hours 09:00 - 19:00 and DropDownListStop displays 10:00 - 20:00. When the user chooses one of the hours in DropDownListStart I want the program to adjust what's shown in DropDownListStop so that the first hour shown is one hour after the hour chosen in DropDownListStart. How can I do that in code behind (c#)? An example: if the user choses 13:00 in DropDownListStart I want DropDownListStop to display only 14:00, 15:00, 16:00, 17:00, 18:00, 19:00, 20:00.