Forms Data Controls :: Unable To Sort Data-Bound DropDownList When AppendDataBoundItems Is True?

Apr 26, 2010

I'm having a problem sorting a dropdown that I've bound to a SQL Server data source. I've narrowed the problem down to the fact that I have a static item at the top of the dropdown with the data-bound items appended afterwards. If I remove the static item (<asp:ListItem Value="-1" Text="All" />) the ORDER BY part of the select clause works fine. How can I get around this issue? What I would like is to have the "All" static item at the top of the list with the data-bound items sorted alphabetically afterwards. I'm using Visual Studio 2010 and ASP.NET 4 if it makes any difference.


View 1 Replies

Similar Messages:

Forms Data Controls :: AppendDataBoundItems On DropDownList Causes Odd Behavior?

Sep 14, 2010

I may just thinking wrong about this but I have a problem that is causing me to want to pull my hair out:

I have two DropDownLists. Call them ddl1 and ddl2. I am binding ddl1 to a DataTable on page_load using if not IsPostBack and allowing view state to keep it populated.

I am then binding ddl2 to another DataTable based on the selected item in ddl1 on the SelectedIndexChanged event on ddl1. My problem is that when I set ddl2's AppendDataBoundItems="true", it just appends the items in the DataTable each time I select a new ddl1 item, so that if I change the selected item in ddl1 3 times, I end up with items in ddl2 from the 2 previous selections as well as the current ddl1 selection.

This doesn't happen when I set ddl2's AppendDataBoundItems="false". Obviously, this is not desiariable behaviour.

View 3 Replies

How To Refresh The DropDownList Without DataBind The DropDownList Because AppendDataBoundItems="True"

Apr 7, 2010

I have a DropDownList in my page, it DataBind with a objectDataSource.

when user select an option base that i have a FormView that show the detail of selected option an it also work with an othere ObjectDataSource.

when user insert, delete or edit an option for example the name of option will in edit mode changed and i need the DropDownList be refresh that show the new name of option.

i alredy know where should i write the code but i don't know how to refresh the DropDownList without dataBind the DropDownList because AppendDataBoundItems="True".

View 2 Replies

Forms Data Controls :: How To Sort Data In Gridview Without Using Bound Fields

Oct 29, 2010

I am using gridview to display some columns with autogenerate column as 'true' and not added boundfields,headers.

And i am used stored preocedure for data source in gridview and i used dataset for gridview databind.

The gridview columns comes dynamically for each time.

View 3 Replies

DataSource Controls :: Dropdown List Causing Error When AppendDataBoundItems Is True

Jul 22, 2010

I have a dropdown list where the user can select a name, on change event populates a Session variable and at the same time populates a formview with the full record detail. I want to add a List Item that states "Select Name" but when I add this the page errors. Input string was not in a correct format.


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.FormatException: Input string was not in a correct format.

Because the value returned from the dropdown list box is a string and not a numeric equal to the first name in the list.

AppendDataBoundItems is = true
AutoPostBack is = true

because I want to update the page as a differnent name is selected. I guess I need to not load the form until an actual first name is selected. Uncertain how to prevent the Formview from loading at page load an until a name is selected and not when the dropdown is set back to "Select Name"

View 10 Replies

Forms Data Controls :: DropDownList Do Not Have Data Bound?

Feb 22, 2011

I got a dropdownlist do not have data bound, but populate the items from an object:

// get employees
StaffBusinessCollection employeeCollection = StaffBusinessCollection.GetEmployees();
foreach (var employeeObject in employeeCollection)
ListItem li = new ListItem(employeeObject .EmployeeName, employeeObject .EmployeeID);

Now I want to get the 'Value' (ie.EmployeeID) of the selected employee.

I tried in the SelectedIndexChanged event but does not work, event the event did not get triggered:

protected void dlEmployees_SelectedIndexChanged(object sender, EventArgs e)
Label4.Text = dlEmployees.SelectedIndex.ToString();

View 2 Replies

Forms Data Controls :: How To Sort Dropdownlist Alphabetically

Jan 24, 2011

I need to sort dropdownlist alphabetically.

This is the code I am using ,its working but it brings numbers first and then alphabets like 1,2,abc,bcc..


View 4 Replies

Forms Data Controls :: Dropdownlist To Sort (ASC / DESC) In Listview

Oct 19, 2010

How to make a sort (asc / desc) in my ListView through a dropdownlist?

View 2 Replies

Forms Data Controls :: Cannot Insert Value Of Bound Dropdownlist In Detailsview

Apr 25, 2010

I have a dropdownlist in the edititemtemplate of a detailsview. The dropdownlist is bound with an objectdatasource. The detailsview is bound to a seperate objectdatasource which connects it to the insert method. When the page loads the dropdownlist is bound properly. However, when I make a selection and select insert I get the following error: Could not find a property named 'DeptID' on the type specified by the DataObjectTypeName property in ObjectDataSource 'objCurrentProduct'. I've tried to remove the SelectedValue='<%# Bind("DeptID") %> attribute. I can then insert without an exception being thrown but the selected value of the dropdown is not recognized. Here is the code:



View 2 Replies

Forms Data Controls :: How To Sort Data In GirdView Via Sort Icons Clicks

Feb 28, 2010

i read Matt Berseth article also i downloaded this source. But i can not do sorting event. Everything is ok but sorting is not working.


View 3 Replies

Forms Data Controls :: Dropdownlist Bound To Sqldatasource Adds Items Instead Of Replacing On Change?

Aug 26, 2010

I have a series of dropdownlists on webform in ASP 4.0. The first drop down is filled upon load, and then when a user selects a value from that list, it populates the second dropdown. To accomplish this, I have a SQLdatasource with a parametersource of the first drop-down list control. This works great, except when a user changes their selection from the first drop down. It performs the query, but then adds the list of items to the ones that were already there from the previous selection, instead of replacing it with the new data. Here is the code:


Do I need to do something on selectedindexchanged to somehow "clear out" the previous datasource? I can't find anything about this online, although one person seemed to suggest it was related to using a master page. (which I am using).

View 3 Replies

Forms Data Controls :: Unable To Bind Data To DropDownList In DetailsView

Sep 15, 2010

I have a slight issue I awas trying to fix for 2-3 days, but nothing I try works.

The scenario:

DetailsView control in edit mode, I pass parameters to the SqlDataSourceProducts (edit.aspx?id=2) and the data source selects the appropriate data and fills in the DetailsView form.

Except two drop down lists. These two DDLs (DDL2 and DDL3) are dependent on the previous DDL (DDL1) in the DetailsView.

when the selected value of the DDL1 changes, DDL2 and 3 change their lists and get bound to the database.

The problem is: when I edit something from the database, DDL2 and 3 appear empty and when I update any other field and leave these, they get blanked in the database.

My goal is to set the selected value of DDL2 and 3 to the values in the database WHERE ID = QueryStringField="id".

I can go for not binding the data unless the field is changed, but does not sound professional and user friendly.


The SqlDataSource used to select the parameters from the table and populate the DetailsView


The code of the fields that hold the DDLs in the DetailsView control


The codebehind:


View 10 Replies

Data Controls :: Unable To Find Columns And Change Its Style For GridView With AutoGenerateColumns True

Feb 10, 2014

I am trying to add dynamically gridview (headerstylewidth, back-color, height, etc…, itemstyle width, back-color, height, etc…), in codebehind but I am receiving this error:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

See the code:

runat ="server"


View 1 Replies

Data Controls :: Sort GridView Using Dynamic Field Values From DropDownList

Mar 14, 2013

I have a gridview which is having coloumns Company name, Industry type, country, employees, revenue. i want to add dropdown at the top of each coloumn so that if user select industry as agriculture, all agriculture industry rows may be sorted, and same for other dropdown also.. i it may be possible,

View 1 Replies

Forms Data Controls :: How To Change Sort Column Header Text And Retain The Sort Link

Jun 3, 2010

I have a simple dynamic gridview with following code -

GV = new GridView();

View 3 Replies

Forms Data Controls :: FormView, AllowPaging=true, And AutoPostBack=true?

Feb 24, 2010

It took me a little while to figure this out, but the AllowPaging="true" on the FormView seems to be the culprit. I don't have much experience paging from a FormView, but for this requirement the customers wants this kind of UI.I have a FormView with DefaultMode="Edit", which is bound to an EntityDataSource. One of the entity's properties, "ExternalID", determines whether some of the other properties in the entity are read-only. For example, if IsExternal==null, the FirstName, LastName, and Email fields should be rendered as TextBoxes. If IsExternal!=null, the 3 properties should be rendered in Label controls.

View 2 Replies

Forms Data Controls :: Unable To Set The SelectedValue Of DropDownList

Jun 15, 2010

My page has a gridview, and the gridview has a TemplateField called "Acciones" (Actions). The column Acciones has a ImageButton with CommandName "Select" and CommandArgument "Tutor". Thus, the GridView has controlled event "SelectedIndexChanged". The idea is that in GV_SelectedIndexChanged, I must to set DropDownList's SelectedValue property. But, the value seted in this function don't affect the rendered dropdownlist. The debugger talk's that the value is correctly seted, but the visual result don't.

View 4 Replies

Forms Data Controls :: Unable To Get Dynamic Generated Dropdownlist Item

Sep 22, 2010

i'm using 3.5 and what im trying to do is create the dropdownlist item dynamically base on value in each datarow, then user select from dropdownlist and click button to postback, when postback system should be able to know what value has been selected by user. the problem with following code is during postback, event of "OnItem_Created" get fired and e.Item.DataItem return null, therefore the dropdownlist will not get populated with the items and that caused the dropdownlist unable to return value selected by user. am i missing anything? is "OnItemCreated" the best place to dynamic create the dropdownlist item?


View 2 Replies

Forms Data Controls :: Unable To Get Multiple Items Selected In A DropDownList Exception?

Jul 21, 2010

I am trying to hide 2 buttons depending on the value in the dropdownlist. It works when the page is initially loaded but chokes when returning to the page sometimes. I have some pretty simple code in the Page_Load event within an If Not Page.IsPostBack statement


View 2 Replies

Forms Data Controls :: Gridview Sort Expression - How To Reset A Gridview Or Prevent It From Doing A Sort

Sep 23, 2010

Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.

I have 1 Gridview that displays 10 different scenarios based on what button is clicked.

I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.

I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.

I tried this:

Tried setting gridview1.sqldatasourceid = null; gridview1.allowsorting = false; gridview1.databind();

Here I get an error that says that the data source does not support sorting? Doesnt it say gridview1.allowsorting = false;

I also tried gridview1.sort("", SortDirection.Ascending); This does nothin... except query my database one more time because i have a onSorting event that looks like this:


Here is an example of just one of those SLQ statements inside GetSQLQuery:


View 1 Replies

How To Set TimeZoneInfo In .NET Data Bound DropDownList To User's Time Zone

Oct 15, 2010

I have a web app hosted with GoDaddy (so the web server is in Arizona - Mountain Time). My users are mostly in Central Time Zone, but I could have some from other time zones. I have a web page with a databound dropDownList using TimeZoneInfo, and I want to set the selected value of this dropDownList to whatever timeZone the user is in. Here's my code currently:

protected void Page_Load(object sender, EventArgs e)
DropDownListTimeZone.DataSource = TimeZoneInfo.GetSystemTimeZones();

It's ok, but I want it to be smarter for those users who aren't in CST. I was hoping there is some way to grab the user's TimeZoneInfo from something like Page.Request.??

View 2 Replies

Forms Data Controls :: Using Event For Data Bound Control Vs Data Source?

Jan 1, 2011

I've been using the Item Inserted event for my data controls, such as details view. I'm wondering if there are advantages to doing this with the data sources instead of the data control. There is a lot of overlap in the events provided by these two types of controls. Are there advantages to using the events raised by the data source instead of the ones raised by the data control itself. Should I be using the events raised by the data source instead of the control used to enter the data?

View 2 Replies

Forms Data Controls :: Display Data From An Itemtemplate Or Any Other Form Views/data-bound Controls?

May 7, 2010

I would like to know how i could display data from an itemtemplate or any other form views/data-bound controls without having it render in tables? i know theres control adaptors, but is this reliable and will it work with 3.5?

View 4 Replies

Data Controls :: Unable To Bind DropDownList When New Row Is Added Dynamically To GridView

Oct 9, 2012

* i binded dropdown value from database in gridview

* then display the value in next column based on selecting dropdown value

* when  i click add new row button . could not bind the dropdown value.

below are my code

<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<contenttemplate> <asp:Label ID="Label1" runat="server" Text="2"></asp:Label>
<asp:gridview ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false">
<asp:BoundField DataField="RowNumber" HeaderText="Row Number" />


View 1 Replies

Data Controls :: Unable To Match Persian Characters From DropDownList In SQL Server Database

May 26, 2013

I have 2 table in database 1-State  2-City and bind DropDownList  1-ddlstate   2-ddlCity from these table and when I select item from ddlsate , according to my selected item from ddlState , ddlcity's Item  change I used OnSelectedIndexChanged for ddlstate

problem is: I enter some data in tables with persian Alphabet now when I select some Item from ddlstate that contain these alphabet in persian  "ی ،پ،... " it didn't show any Item in ddlcity but when I select item that didn't contain above  alphabet it show item in ddlcity correctly why this happen?

View 1 Replies

Copyrights 2005-15, All rights reserved