Web Forms :: Setting A Dropdownlist That Is Binded To An Sqldatasource To A Particular Datavaluefield Id?
Apr 30, 2010
So I have a major issue and cannot find any solution online to solve it excepting one that is singlistviews. But i am also encounting some probs with listviews since i am not sure of to use it.Anyways so my major issue is that I have drop down lists that are being populated by a sqldatasource. Users are filling out a form selecting values in the drop down list which is fine, the prob exists with editing a record. I have the dataValuefield to be the Id of the data and the selected item in the dropdownlist id is being stored in a database. So I have the data in the database that is the Id of the selected item however I cant use the dropdownlist1.selectValue ='idNo' since that only works with listitems.
How can i access the dynamic rows in a dropdownlist that is being populated by a sqldatasource and set the selected item to a particular item?Any insight is greatly welcome. Even how to use listviews
I'm currently working with a control that inherits from DropDownList (it has some extra functionality that isn't really relevant to this question, but it gives me a nice place to implement the extra stuff I'm gonig to discuss).
We're using data binding, with the DataTextField and DataValueField working absolutely fine. However, I find myself in need of a similar field that will control whether or not the item is enabled. (I've already overridden the RenderContents method of the control so it properly renders non-Enabled items, since DropDownList doesn't do this by default.)
Thus I'd like to know how to override the DropDownList's data binding so it acts exactly as normal, except a further field from each DataSource item is applied to each ListItem's Enabled property.
(NB: the field I'll be binding to isn't a straight boolean, and doesn't have an explicit/implicit cast to boolean, so I'll probably be "passing" it as a string.)
I have a dropdownlist for which I am loading data from excel. Excel has 2 columns Product and Email. Data in Product column is binding to DataTextField and Email column to DataValueField. The dropdown works fine when email is different for different product but when email has same value for different product then whatever I select, on postback the selected value changes to the first item of the same email value.
Below are the sample data in Excel to show the behavior of dropdown
Example 1. (Drop down works fine for this example)
Example 3. (In the example below, when I select iPad the dropdown works fine but when I select iPhone 3G or iPhone4 on post back the dropdown selected value will be iPhone 3G. Basically, on selecting iPhone4 here, on post back it shows iPhone 3G)
I am trying to pass the parameters dynamically thru Sqldatasource and get the results in grid view. Based on the dropdown list selection it has to show the results in grid view. When I hard code its giving correct results but when passing thru parameters i'm unable to get the results in grid view.
Output shud be something like this:
Select the value: 123
124
125.
Lets say user selects '123', the query it runs in sqldatasource is Select col1,col2,col3 from table1 where col1 LIKE '123%'
results will be 12301,12302,12303 with other columns in grid view.
I need to pass a user selected value from a databound DropDownList into a GridView SQLDataSource select statement so the correct records will be selected. I have found lots of documentation on DropDownLists and sqldatasources but nothing that connect the two.
I am facing a small issue in using a DropDownList that has only two values (AND and OR) which i want to use to configure a SQL Query in a SqlDataSource. How can i use this thing by passing the value in a SqlDataSource Select Query in such a way to Bind the Result to a GridView. I want something like this -
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen @Option InvoiceNo = @invoiceno where @Namen is from a DropDownList and InvoiceNo is from a TextBox
I m having a problem in specifying this @Option parameter from a DropDownList which contains only two list items - AND and OR. On the Basis of the Selected Value from this DropDownList i want to execute query like
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen AND InvoiceNo = @invoiceno
or
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen OR InvoiceNo = @invoiceno
Using the Query with @Option gives me a Parsing Error. Why is that so. How can I implement this scenario.
I am trying to use a DropDownList in a DetailsView for the ItemTemplate, InsertItemTemplate, and EditItemTemplate. I must bind this DropDownList to a SQL-Server support table using a function that returns a DataTable. I am not allowed to use a SQLDataSource in my backwards IT department. So, not only do I need to load the DropDownList, I also need to make the SelectedValue equal to the current record that I am viewing, editing.
I have a dropdownlist that's being populated from a SQL datasource. I would also like to have a tooltip for each dropdownlist list item on mouse over. I found the example below which adds a title attribute for each list item using the listitem text as a tooltip but I want to make the title/tooltip value another field in the database. In other words,
I have a ASP.Net webform with a DropDownList control. This Dropdown gets it's values from a states table in an ObjectDatasource. The Dropdown contains states spelled out.
If I try to set the drop down to: DropDownStates.SelectdValue = "Ohio"
I get an error that the value does not exist in the dropdown even though it does exist. But if I pad the value with the correct number of spaces to the right, it works like so: DropDownStates.SelectdValue = "Ohio " or DropDownStates.SelectdValue = "Michigan "
How can I either define the dropdown without trailing spaces in the value of the dropwdown or set the SelectedValue with adding trailing spaces?
My problem is I need to set selected value of a drop down list to a value I retreive from a database. The example only has a know value.
Below is the HTML and Code. <asp:DropDownList id="ddlCatogory1st1" DataSourceID="srcCatogory1st1" DataTextField="CategoryName" DataValueField="CategoryID" AutoPostBack="true" Runat="server" /> <asp:sqldatasource id="srcCatogory1st1" ConnectionString="server=(local);database=db;Trusted_Connection=true" SelectCommand="SELECT CategoryID, CategoryName FROM Categories WHERE ParentCategoryID is null ORDER BY CategoryID" Runat="server" ></asp:sqldatasource> Sub Page_Load() DISPLAY_CATEGORY() End Sub Sub DISPLAY_CATEGORY() ddlCatogory1st1.DataBind() ddlCatogory1st1.Items.FindByValue("A").Selected = True End Sub
When I run this page I get
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 222: Line 223: Sub DISPLAY_CATEGORY() Line 224: ddlCatogory1st1.DataBind() Line 225: ddlCatogory1st1.Items.FindByValue("A10").Selected = True Line 226: End Sub
Even if I take out the databind I get the same error.
Two ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty); Error: There is no source code available for the current location. and Returns null value
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:
[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).
I'm populating a dropdownlist in a formview with a different datasource from the formview's. I need to set the selected value according to the value in the formview's datasource but I'm having a hard time doing that.
Here's the code: <asp:FormView ID="FormView1" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource1"> <EditItemTemplate> [code]....
I have a problem in setting the selected index /value in a drop down list. The list is bound by a Linq query and I want to add an item at the top of the list and set it as the selected item.
THis is the code i am using
ListItem li = new ListItem("Select", "", true); list.DataSource = (from ap in edc.Approvers where ! ap.approverEmail.Equals("") orderby ap.approverEmail select new {ap.approverEmail}).Distinct(); list.DataTextField = "approverEmail"; list.DataValueField = "approverEmail"; list.DataBind(); list.Items.Add(li); list.Items.FindByText("Select").Selected = true;
The listItem li is the item i want to be first in the list and also selected. Adding this before the databind just loses the item.
I have officially wasted about two days trying to figure out what the heck was going on with my asp.net page. I actually thought it was an issue with my updatepanel code, but after reading another post I was able to reproduce the same results. [URL]
I just manually added the following control to the page (no code behind for the listbox) and it is nested in an ajax tabcontrainer inside an updatepanel. If you set item 20 as selected the page flickers when loading that tab. I tried the css mentioned (style="overflow:hidden") on the tabcontainer,tab panel, update panel and dropdownlist, but no luck. Crazy select item 19 no flicker, 20 (which is actually the 21st item) and it does flicker. This is driving me insane. And yes this only occurs in FireFox ( running 3.6).
In our asp.net web application we load the dropdown list boxes in the page load. We than set the SelectedValue of each dropdown list box to an object from session. We have event handlers for many of the SelectedIndexChanged events of the drop down lists boxes, but these do not get executed when we set the selected value programmatically.
Someone else mentioned this is by design, and only when a user manually changes the drop down list selected index, will the event get raised.
I would think this is a common scenario of wanting the selectedindexchanged event handled when setting the selectedvalue/selectedindex/listitem's selected property, of a DropDownList. What is the suggested way to handle this? Is there a significant drawback of creating a custom control inherited from DropDownList that has the functionality of raising this event when changing the SelectedIndex or SelectedValue?
I'm using radcombobox and radgrid.Here i want to display ward_no but store ward_id in database.But in my code ward_id field not store, ward_no is store. What is the problem?
