Forms Data Controls :: Populate DropDownList In InsertItemTemplate After Insert?
Sep 18, 2010
I thought this one would be easy, but no go. What I am trying to do is the following: I have two DropDownLists in my InsertItemTemplate, each bound to its own datasource. After the fields in this form have been filled out and the ItemInserting event fires, I rebind the ListView to its datasource, but the DropDownLists turn out empty. I tried to bind them in the ItemInserting event and it seems they get filled, but nothing shows up in them when the page loads. I also tried to fill them in the ItemDataBound event, but the e.Item.ItemType == InsertItem doesn't do it.
I am new to asp.net and am hoping this is an easy question. I have a gridview and then I have a couple of dataviews whose sqldatasources looks to the gridview' to be populated based on an ID number in the first column. If there are no rows returned to the dataviews, I generate an insertitemtemplate.
The problem is that I want to pass the value from the ID column in the Gridview over to the insertitemtemplate (because I don't trust the end user to get the ID right). The insertitemtemplate is now blank in all fields. ( I'm doing this in C#).
I have a Gridview which I'm populating through code behind. A couple of columns of the gridview I've set up to be drop down lists. What I want, is that when I run my Insert query, it takes the drop down list selected value, finds the appropriate ID and uses that ID as part of the insert query.
The Insert row in the ListView has an empty DropDownList and GetCountries() is not called. However, if I click the Edit button on an existing row, GetCountries() is called twice (not sure why) and the DropDownList is properly populated. Why isn't the InsertItemTemplate DropDownList getting populated?
I have a dropdown list in ListView control in InsertItem Template. I want to bind the DropDownList when I Click on Link. I want to bind it in CodeBehind not to use Datasource. I tryed lot but not finding the DropDownList. See My Code....
<InsertItemTemplate> <tr> <td colspan="7"> </td> </tr> <tr> <td colspan="7"> <table border="0"> <tr> <td> </td> <td> Sector</td> <td>:</td> <td align="left"> <asp:DropDownList ID="DropDnSector" runat="server" ></asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" Display="Dynamic" ControlToValidate="DropDnSector" SetFocusOnError="true" ValidationGroup="vgUpdate">* </asp:RequiredFieldValidator> </td> </tr> </table> </td> </tr> </InsertItemTemplate> lnkNew is my linkbutton outside the ListView Code Behind: Protected Sub lnkNew_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkNew.Click Try lvSubscription.InsertItemPosition = InsertItemPosition.LastItem lvSubscription.EditIndex = -1 BindDropDownList() fn_ShowSubscriptionLevel(fn_BindSubscriptionLevelEvents) Catch ex As Exception fn_ShowMessage(ex) End Try End Sub ------------------------------------------------------------------------------------------------------------------ Protected Sub BindDropDownList() Try Dim objSector As IEnumerable(Of SystemBuilder.SystemBuilder_Sector) Dim objSubscriptionLevel As SystemBuilder.SystemBuilder_SubscriptionLevel Dim DDLSectorctrl As DropDownList objSector = CSectorDB.CSectorInstance().GetAllSector() If (lvSubscription.InsertItemPosition = InsertItemPosition.FirstItem Or lvSubscription.InsertItemPosition = InsertItemPosition.LastItem) Then DDLSectorctrl = CType(lvSubscription.InsertItem.FindControl("DropDnSector"), DropDownList) If DDLSectorctrl IsNot Nothing Then DDLSectorctrl.Items.Add(New ListItem("--Select--", "0")) For Each ObjRec As SystemBuilder.SystemBuilder_Sector In objSector DDLSectorctrl.Items.Add(New ListItem(ObjRec.SectorText.ToString(), ObjRec.SectorID.ToString())) Next End If ElseIf (lvSubscription.EditIndex >= 0) Then Dim DDLSectorctrl1 As DropDownList DDLSectorctrl1 = DirectCast(lvSubscription.Items(lvSubscription.EditIndex).FindControl("DropDnSector"), DropDownList) If DDLSectorctrl1 IsNot Nothing Then DDLSectorctrl1.Items.Add(New ListItem("--Select--", "0")) For Each ObjRec As SystemBuilder.SystemBuilder_Sector In objSector DDLSectorctrl1.Items.Add(New ListItem(ObjRec.SectorText.ToString(), ObjRec.SectorID.ToString())) Next objSubscriptionLevel = CSubscriptionLevelsDB.CSubLvlInstance().GetSubscriptionLevelDetailsBySubscrptionID(ViewState("ID")) If objSubscriptionLevel IsNot Nothing Then DDLSectorctrl1.SelectedValue = objSubscriptionLevel.SubscriptionID.ToString() End If End If End If Catch ex As Exception End Try End Sub
I've been trying to find a solution to my problem for about 2 days now, and have found nothing. I am new to .net and not really sure how to accomplish this. I have 4 tables in a database, Vendors, RepairCos, Cons, ConRepairHistory. What I'm trying to do is make a page called SendOutForRepair.aspx that has a insert item template where the first control is a dropdownlist that is attached to the Cons table (got this figured out) and is populated with the Serial Number field. I would like the selection from the dropdownlist to populate the 2nd control (VendorID) that is also from the Cons table....
I am using 3 dropdown list in a gridview and the values for the dropdownlist is dynamic from database.based on first dropdown list selected value the values must fill to second dropdown and based on second dropdownlist selected value then items should load to 3rd dropdown and same for 4th dropdown list. Here if i select age,gender,sex, fist name, last name from the template name Human. The first drop down only populate the fields like Age,gender,Sex and so on., When the second dropdown list populate from the fields corresponding Template name Human, Finance, and so on.
When someone selects one of the search criteria, I want the other dropdownlist boxes to re-populate with only the information from the current search and take out all other information if that makes sense. This search functionality works except it the dropdownlist boxes stay populated with all information originally loaded from the database. Here is my code:
I have a pretty simple scenario using manual data operations with rad list view. I insert an item into my collection in the Item Inserting event,the list view shows the new item but the insert item template is still showing.Is my setup wrong?Do I have to manually hide the thing?
I am trying to populate a gridview when you select the dropdownlist.selected value. I don't want to use the sqldatasource or any other datasource. I am trying my best to achieve this, but didn't succeed till now. One of my friend said that i need to get the selected value from dropdownlist and search for the data in the database using the selectedvalue and populate the dataset and bind to the gridview.
I have a ddl inside the formview that I can't figure out how to wire up properly. The formview contains detail info, but the ddl needs to list the entire set to items. Then I want the ddl's selected value be set from the recordset intended for the formview. I think it's just a timeing issue s I would like your help. Thanks, - EJM.
I have a dropDownlist in a Formview Edit and Insert Template that is Bound to a Field, It is for a credit card expiration date, so I want to programatically populate it so it will automatically show the next 8 years from this year. Works fine!
Except When I add it to the Formview, and click on edit it gives me an error basically saying my record does not match the list item data, but it should since it shows the year just fine. So I am figuring that it is not binding the ListItems to the dropdownlist.
I have tried every event I could try and I always get the same error. I have tried the ModeChanged, DataBound, DataBiding, PreRender, Load on both the Formview and the DropDownList, but no go. How do I do this?
[Code]....
This works fin on a DropDownList that is not in a FormView, so I know its not the Code. and the record I am updating is 2010, so the record is not out of range
I have a dynamically generated dropdownlist, that lists e.g. Company Names. I want to be able to select a particular Company and display associated information e.g. Name, Address, City, State... etc. in text boxes adjacent to the list.
I am trying to fire the following code from the dropdownlist "OnSelectedIndexChanged" property, but cannot 1) get the code to fire upon selection, and 2) populate the text boxes...
So I have a dropdownlist and I'm trying to populate it with values in the database. For some reason, half of the rows has no value. It's happenning in a sequence as well, like the first row has no value, then the second row has value, then the third hasno value....
In my project I have a listview which I am binding from code behind. Now I would like to add a droppdownlist for each item in listview. So my question would be:
Is there a way to populate my dropdownlist whit data which I have in a List?
Here is a bit of code to show how my listview looks like:
I have been trying for a while to populate a formview when I select an item from the dropdownlist. The dropdownlist is outside of the formview. For some reason, when I select a different item it does not change in the formview. Only the first item of the list shows up. I don't know where I'm doing wrong. I tried many things and suggested informatioin and I still could not get it to work. When I do try to switch I get this error message:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
I'm trying to programatically populate some dropdownlists inside a formview in EDIT mode, like this below.
[Code]....
I orginally had this running as part of the pagelaod event, but I'm thinking that b/c the page loads first, it doesn't populate the fields in EDIT mode until after the data is saved, and then page is reloaded. Now it knows it's in "Edit" mode. Am I thinking clearly here? Not sure if this is the order of things. So I thought I should just use a formview_modechanged (or similar event) so when the user switches modes, it populates the fields - but I'm not sure which event I should use. I've tried "Modechanging", "modechanged", "prerender", etc, but with no luck. Here's my new code... not sure what's up? Is it simply I've got the wrong formview event? Or am i missing something? Is there an easier/better way to accomplish this?
I have no problem when paging my FormView, the dropdownlist does not read the next record and keep the value of the first loaded record? All other textbox control behave normally and move from record to record excepted the ddl??Here the code.
Public Sub DoData() Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString) Dim myCommand As SqlCommand = New SqlCommand("SelectSupplier", myConn) myCommand.CommandText = "SelectSupplier"
How to populate a DropDownList (using C#) inside a DataList while page loads.....yes we can do it by using DatasourceID propeerty in aspx page itself(as I've done here..), but how do I do using C# in code behind only?
I would like the user to select an item from a drop down list. Next to the drop down is a textbox or label control. From the ddl selection I would like to populate the textbox or label from a database with a corresponding field from the database the dropdownlist was populated from. On selectindexchange event I can populate the textbox with the Unique id from the value, but I need to input a different field into the textbox. Can I use some sort of variable to assign the Textbox.Text = ?
The situation: a FormView with an EditItemTemplate and an Insert Item Template. When the page is entered and a record exists in the datasource, everything is fine with the Formview in Edit mode and the Edit ItemTemplate being used. But when no record is present, the FormView uses the EmptyDataTemplate even though it was switched it to Insert mode. Here is the code used to switch modes, fired in the OnDataBound event:
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. error when I place a drop down list into my instert item template of my listview, but I have the exact same control in my edit view and it works fine, any reason I am getting this error? I know what it means but why would it work in the edit mode, and not the insert mode?
