i have panel i want to add 4 dropdownlist wwhich have sqldatasource1 dynamically then add 4 dropdownlist that have sqldatasource2 but sqldatasource2 have select sql statmentDepends on sqldatasource1 that do ok
but when i chang index for first dropdownlist the 2nd dropdown not change dirctly how can i databind for next dropdown
I have a drop down menu that is populated on page load. Below that, I have a gridview that has a select parameter based on that drop down menu's value. I can't get the gridview to populate with data based on the drop down. If I fill in the parameter with a constant, the data pulls fine, but when I switch the parameter to a form parameter, it won't pull.
Here is the relevant piece of the aspx page:
[Code]....
Here is the relevant section of the code behind:
[Code]....
i'm opening a new window and passing on to it variables in a querystring, the values are loaded into a function that is filling my dataset and then filling my Gridview. after i press the button field in my grid to delete an item, the databind doesn't show the updated grid but remains the same. i've noticed that if i navigate back and refresh i see it correctly. in FF btw no problem.
the code:
this is used to open the new window
[Code]....
[Code]....
[Code]....
[Code]....
Does 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 the gridview control with 2 dropdown list and 2 text boxes,When the textbox chnaged event happen 1 row will create and the dropdown back to initial values( its not retaining the selected values),I am binding the control after text changed method,Is there any properties needs to be set or any other way we can retain the values in postbacks?
View 4 RepliesI have a gridview where i have two fields. one is product and second is sub category.
I need to do 2 things.
1. I need to populate the two combos from the database. But depending what is selected in dropdown 1 this will determine what needs to be populated in drop down 2?
how can i achieve this?
I have two dropdown linked with sqldatasources.When I select item in ddl1 then on the basis of selection ddl2 is being loaded.Is there any possiblity that if I select ddl2 then ddl1 will also load on the basis of selection?
View 3 RepliesI am a complete newcomer to ASP.NET. However in the few weeks I have been playing with it I have got pretty far and have mastered things like stored procedures, gridviews, formviews and templates.I have a dropdown box which is populated from SQLDataSource1
I have a second dropdown box which is populated from SQLDataSource2, but i need the query feeding this to be dependent on what was selected in the first dropdown box. I assumed it would simply be a case of modifying the select statement on SQLDataSource2 using the SelectedIndexChanged event on the first DropDownList to update the second SQL source, but I cannot work out for the life of me how to do it. Pretty much all of the code I have is ASP.
can i do this purely in ASP rather than using VB behind the scenes or do I need to use VB? I am pretty comfortable with vb.net but one of the other issues I have is referencing an ASP object from VB... so for instance if I had a text box in ASP, how can I read or change the properties of this object from VB?
FYI I am using Visual Studio 2010 and SQL/Server
creating a dropdown similar to the time dropdown in outlook, located in the recurring event. The dropdown shows intervals of 30 minutes based on a 12 hour time format and allows the ability to put text in it.
View 1 RepliesI have seen article in code snippet but i have never used web services so that is complicated .
View 1 RepliesI'm having a problem with using a dropdown to filter the contents of another drop down. The basic idea is:
Dropdown 1 = CountryList (Column1)
Dropdown 2 = StateList (Column2)
I read the contents of a CSV file and populate the gridview. The user then visually verifies that the data is valid and proceeds to upload to the database. To do some testing, i have intentionally changed spellings of country names so they DO NOT match the countrylist which the grid view then flags with a different background indicating bad data. The user then edits the gridview. The Country and state columns then show a drop down control populated with the country list and filtered states list based on countryID.
Here's the ASP.NET ASPX Source for the section of code that is dealing with the gridview
[Code]....
Here's the section of VB Code behind that deals with handling the "RowEditing", specifically the binding of the dropdowns
[Code]....
The proglem is that these dropdowns are ment to easily fix minor errors in data. When i intentionally changed the spelling of "Canada" to Canadaa", this has no corresponding CountryID in the table and the ddlEdtStateID Dropdown's datasource filter does not work. I tried setting the datasource to nothing if a valid CountryID was not there and then i tried to use the SelectedIndexChanged event for the ddlEditCountryID to programmatically set the datasourceID for ddlEditStateID but when i try using CType(FindControl("ddlEdtStateID"), DropDownList) to set the DataSourceID, it does not find the control.
If the Country does not exist, then i just want the stateslist dropdown to say "select a country" but when a valid country is selected, it should display the filtered list for that countryID. Right now, if bad data is entered for the country, then the program crashes when it tries to populate the state drop down. I want it to just say, select a country when the countryID is not valid.
I have been attempting to Databind a control's ID inside of a datalist all day.
Does anyone know if that is possible?
I need to databind a LinkButton's ID, but have run into this error:
<dx:ASPxHyperLink ID='<%#Eval("name") %>' runat="server" Text='<%#Eval("Text") %>' />
Parser Error Message:
The ID property of a control can only be set using the ID attribute in the tag and a simple value. Example: <asp:Button runat="server" id="Button1" />
I can use any html control that will allow me to display databound text and databound ID
How do i databind from database into listitem?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyDbConn %>"
SelectCommand="SELECT * FROM [Questions]"></asp:SqlDataSource>
<asp:RadioButtonList runat="server">
<asp:ListItem><%#Eval("option2")%></asp:ListItem>
</asp:RadioButtonList>
This is my setup: I've got a dropdownlist of people and a linkbutton next to it to add a person. the linkbutton makes an update panel appear. When clicking save, I want the data to be saved and the new person be selected in the dropdown. As far as I can tell, I have done this properly. After I save the data I refresh the dropdownlist and take the new person's value and set it as the selected value. When stepping through, it shows the ddl with the new person and the new person selected! BUT, when the page comes back, the ddl is unchanged, ie NOT refreshed. I thought it might be something with the Update Panel but I got a similar setup to work on another page! It also works on a nested Update Panel (not shown in the following code). Can you think of why this "deception" is happening?
Here is some of my code.
[Code]....
I am using a repeater control that is bind with a data reader. In <itemtemplate> i am trying to create a hyperlink that would be something like ....
[Code]....
but for some reason its not rendering the actuall value seems like some thing wrong with the concatination i am doing ...
I'm databinding the checkbox list to a db table which has a category assigned for multiple records. I can list the checkbox but I can't sort them by category using the checkbox list control. Can somebody post an example on how to achieve this? Category 1chk Record 1 chk Record 2 chk Record 3Category 2chk record 4 chk record 5 Etc
View 3 RepliesI want bind more than 10000 records in gridview and improve performance.
View 1 RepliesI have dropdown1 that has some items in it.I also have dropdown2 that gets populated from a database based on whatever is selected from dropdown1.Dropdown2 has its first item as "Make Selection" and then appends the data from the db based on what was selected in dropdown1.
Now when I select an item from dropdown1 it puts the correct data in dropdown2 but as soon as I select another item from dropdown1 it appends those values into dropdown2. How can I remove the values from dropdown2 after a new item is selected from dropdown1?
How to fill the value in drop down box according to value selected in another drop down box?
View 1 RepliesHow to get the first letter from dropdown value and append with second dropdown
I want to get the first character of dropdown selected value and append with second dropdown selected value.
Eg
i kept two dropdown control in page
five values binded in 1st dropdown
like
1. reebok
2. nike
3. puma
4. woodland
5. Leather
and
five values binded in 2nd dropdown
like
1. prod1
2. prod2
3. prod3
4. prod4
5. prod5
here i am going to insert into table in below format
i wand to append the value like this rprod1 (r is a reebok from 1st dropdown and prod1 is second dropdown) .
eg
nprod1
pprod1
I've written a custom control that converts datasources into an IEnumerable and then binds the data. This works fine and I have LoadPostData working after postbacks. I can also using a collection to load it. Like adding listitems to a dropdownlist on an html page. This works fine and I have LoadPostData working after postbacks
[Category("Behavior"),
Description("A collection of CheckBoxItems"),
DesignerSerializationVisibility(DesignerSerializationVisibility.Content),
NotifyParentProperty(true),
PersistenceMode(PersistenceMode.InnerDefaultProperty)]
public CheckBoxFieldCollection CheckBoxItems
{....}
Kinda struggling on merging the two. I think when i databind, instead of adding my CheckBoxItem to Controls I think I need to add it to my collection CheckBoxItems and then proced with creating childcontrols. It works the first pass through when I bind to the datasource. When I do a postback my controls collection goes to null. Can anyone point me in which direction to go? Also, after databinding, if I do , MyControl.CheckBoxItems.Add(new CheckBoxItem(..)), the new one doesnt show up.
How can I databind a MenuItem to a SQLTable entry?
View 5 RepliesI hava a Gridview connected to an objectDataSource. I only want the gridview to databind when a button is clicked. My problem is that the gridview-ObjectDatasource databinds everytime the page does a postback.
View 5 RepliesI have worked a lot with gridviews, etc, but I am relatively new to Repeaters and I have a page that uses a Repeater to display records from a SQL Database. By default the date in the SQL field is 01/01/1900. I need to format the dateSHAWSTART & dateSHAWEND in my repeater so that if the date is 01/01/1900 that the fields should be blank. Here is my VB Code Behind:
[Code]....
My repeater code on my aspx page:
[Code]....
Has anyone been succesfull databing the InsertTemplate of a ListView to an SQL datasource?
My ListView is databound to a SQLDataSource however the InsertTemplate needs to be initialized to the last entry/record on the database
So I can create a second datasource to grab the last record from the database but how do I bind it to the InsertTemplate?