.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Dealing with a databound DDL inside formview when SelectedValue no longer exists

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :ASP.Net
Hi forum heros!  I have a page that has a formview on it.  Client info, name, address, usual stuff.  The formview is populated by a DataSource, that calls a SQL stored procedure for the client info.  It all works great. Within the formview, I have a dropdownlist for the Staff assigned to the client (StaffId is a member of the Client record called during the Formview binding).  When the formview is in Item mode, the Staff name appears in a label, when in Edit mode, the dropdownlist is bound and populated by another DataSource that calls a stored procedure of ActiveStaff. When the assigned staff exists, the StaffId is correctly bound to the DDL SelectedValue and the current staff name appears selected in the DDL when in edit mode, as it should. So here's the problem: Staff quit and become inactive.  So when the client record is pulled up, the StaffId (bound from the Formview) is no longer in the ActiveStaff list (used in the DDL) and the DropDownList bind fails (loudly - not sure why it couldn't just fail to zero, but there you go). Anyway, I know how to check for whether a record exists and manually bind dropdownlists that are outside formviews, but is it even possible within a formview? Any direction here would be appreciated. Thanks in advance.  

View Complete Post

More Related Resource Links

DropDownList inside FormView Insert Template

Hi, I am trying to change the textboxes in the FormView insert template to dropdownlists but they keep setting the parameters to null.   Here's what I have:  <asp:DropDownList ID="ddlYearOfQualification" SelectedValue='<%# Bind("YearOfQualification") %>' runat="server"> </asp:DropDownList> In Page_Load CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2010", "2010"))CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2009", "2009"))   and in the SqlDataSource InsertCommand="INSERT INTO [tblSurvey] (... [YearOfQualification] ...) VALUES ( ... @YearOfQualification ... ) And in insert parameters: <asp:Parameter Name="YearOfQualification" Type="Int16" /> And the insert fails with YearOfQualification as null. If I sue the standard textbox: <asp:TextBox ID="YearOfQualificationTextBox" runat="server"                 Text='<%# Bind("YearOfQualification") %>' /> It works.   Any ideas? Many thanks in advance.

Selected value of RadioButtonList inside a formview get cleared on button click.

Hi all,I placed a RadioButtonList inside a Formview control.And from  DataBound event handler of formview ,RadioButtonList is binded to the datasource .Now my problem is after selecting a value from radiobuttonlist and I click any button,the radiobuttonList get unchecked and lose the selected value .How can I avoid this.Please help..

AsyncFileUpload inside FormView not working

I'm having a lot of problems with something seemingly simple, and from other posts sounds like people have been able to do. I have a FormView inside a user control, and in the InsertItemTemplate, I have an AsyncFileUpload control, that I would like to to use. On the user side, it seems to work, but it doesn't work on the server side code behind. The HasFile Property is always false, and it doesn't fire the UploadCompleted event either. My UpdatePanel is in the master page. Any ideas? Thanks <asp:FormView ID="frmAddImage" runat="server" DataKeyNames="imageID" DataSourceID="sqlImages" Width="100%"> <InsertItemTemplate> <cc1:AsyncFileUpload runat="server" ID="FileUploadImage" Width="400px" UploaderStyle="Traditional" CompleteBackColor="Lime" ErrorBackColor="Red" onuploadedcomplete="AsyncFileUpload_UploadedComplete" UploadingBackColor="#CCFFFF" />  

Panels inside Formview


I have a FormView, and I want to put a panel inside it's EditTemplate and then acess it when the dropdown is changed so that the FormView calls Edit. Then they will become visible. How can I call them to visible if I can't reach them?

So, how can I make Panels inside EditTemplate in FormView as variable reachable so I can change their visibility?

            "PanelRegSala.Visible = true;
            PanelBusca.Visible = true;
            PanelGrid.Visible = true;"

"<asp:Panel ID="PanelRegSala" runat="server" Visible="False">
          <asp:FormView ID="FormViewRegSala" runat="server" DataSourceID="SQLDSRegSalas" DataKeyNames="idSala">

asynchronous fileupload inside formview


Hi All:
I have a page with master page. On that page there is a formview inside updatepanel.  Form view has asynchronous file upload control. Its uploadcomplete event is never hit. Can you please suggest me solution for it ?
 <asp:FormView ID="dvCustomerDetail" runat="server" DefaultMode="Edit">

Postbacktrigger inside Formview


Hi All:
I have a formview inside modalpopup which is inside updatepanel.  The formview contains a button. I want to add postbacktrigger to updatepanel. but when i add postback trigger, I get error that button is not found as it is enclosed in formview. How can I add postback trigger. Also, I dont want the popup to be closed when that button is clicked. 
Please suggest me solution.

Databound dropdown list inside detailsview filtered dependent on selected radiobuttonlist item


It's driving me mad.  I have a detailsview bound to an sqldatasource. One of the items on the data table is to get its value from a dropdown list, so I created a template field and entered a dropdownlist, then bound that to a second datasource with the selection values in it. As the values can be male or female related, I have an unbound radiobuttonlist above the dropdownlist with two values - male or female - retunring an d"m" or an "f" and I want to use this to filter the records coming from the second data source for the dropdownlist.

I can't use a normal SQL control parameter on the datasource as the selector (the male/female radiobuttons) are in the detailsview and therefore "invisible".  I set up a normal control parameter with "none" as the type.  I then set the "autopostback" value to "true" for the male/female radio buttons and tried writing in the code-behind for the "maleorfemale_SelectedIndexChanged" event and using debug lines revealed that I was getting the "m" or "f" I needed by using "findcontrol", so that's fine.

I also tried adding in the "selecting" event for the second datasource to use the value of the radiobutton item, but although the "selecting" event fires

Formview's control collection empty when placed inside an AJAX accordian content pane.



The following problem occurs:

I have an accordian content pane on my page holding a formview. At code behind I can iterate the control collection of the content pane using FindControl and find the actual formview control. However it seems that when a formview is placed inside an accordian pane the formview itself looses it's control collection items.


So my problem is at codebehind I can get the FormView control, but it's control collection is empty, when placed inside an accordian content pane.

Using recursive find control function also doesn't help since there are no more items.

check if file exists inside foreach container?


Hi All,

I have a foreach container that checks a folder C:\FTP for an Excel file named Fast_<date>.xls, imports the data, and copies the file to C:\Archive.

I need to add a step that checks C:\Archive for a file with the same name as the file in C:\FTP before the import step.  If the file is already present in C:\Archive, the package should fail.  If it isn't, then it should continue normally.

I found a promising-looking link in a previous post, but the referenced page no longer exists (below).   I have never used a script task, and I will have a different file name each time, so I am a little confused. 

If someone's feeling benevolent, suggestions would be very much appreciated!!

Thanks in advance!

broken link: http://agilebi.com/cs/blogs/jwelch/archive/2007/10/31/checking-for-the-existence-of-a-file.aspx


Accessing the different controls inside a GridView control

how we can access a particular control which resides inside a GridView control. In this article I will show you how you can access different controls inside a GridView control. We will see how we can access a TextBox control, a DropDownList control and a ListBox control. If you are working with ASP.NET 1.X then you might want to check out my article Accessing Different Controls Inside a DataGrid.

How To Add calendar control inside a GridView

This article show hot to add calendar control inside a GridView with code in c#

Using ATLAS PopUp Control with Calendar inside the GridView Control

In this video tutorial Mohammad demonstrates how you can access the Calendar control which is displayed using the ATLAS PopUp control inside the GridView control.

RadioButton inside GridView, How to get it work as normal

Did you tried before to drag a RadioButton control inside a Gridivew templatefield, and then you attempt to select these RadioButtons , you will notice that the behavior of RadioButton control will be changed and it will work just like the behavior of checkbox control! the user will be able to select more than one radiobutton in the grid!

Maintain HTML Radio Button Selection Inside GridView After Postback

Long time ago I wrote an article about getting the value of the selected RadioButtons inside the GridView control. The code did not addresssed the postback issue which means that the selected radio button was cleared after the postback occurs.

LinkButton inside Repeater



I have Repeater, which consists of LinkButon and Literal. LinkButon and Literal are whole thing by implication. I want get value from Literal, when user click on corresponding LinkButton.


Formview LinqData source not allowing updates


OK, I'm confused.  I've set up a formview with a Linqdata source to allow users to edit records.  When I run it, edit data and submit, it blows up and tells me "Linq datasource6  does not support the Select property when the Delete, Insert or Update operations are enabled."  I googled that warning and saw a couple of posts on this forum saying the problem is the slect statement has to be removed from the Linq data source for it to allow updates. 

But if I remove the select statement then how do I show the user specific info on pageload?   plus I thought the two way databind was an advantge of the datasource control.




Textbox in ItemTemplate inside Gridview, unable to get the value


Hi. I have a itemtemplate inside a gridview.

<asp:TemplateField HeaderText="Enter OTP">
                            <asp:Label ID="Label2" runat="server"
                                style="font-family: Arial, Helvetica, sans-serif; font-size: x-small"
                                Text="PIN Num:"></asp:Label>
                            &nbsp;<asp:TextBox ID="txtPIN" runat="server" Height="21px" Width="100px"></asp:TextBox>

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend