Solved

How do I get selectevalue from DDL into ODS insert?

Posted on 2010-09-15
6
393 Views
Last Modified: 2012-05-10
I have a form with an objectdatasource in it and three simple controls. I want to insert the selectedvalue from a databound dropdownlist into the objectdatasouce insert parameter "CommitteeID". I've tried several different ways and it's just not working. This is the latest iteration:

EVerything else works, but the selected value of the dropdownlist. It's almost like the insert happens in the page cycle prior to the dropdownlist selectedvalue coming back from viewstate. Please help. This is driving me crazy. This should be VERY simple.
<table style="width: 100%">

        <tr>

            <th>

                Committee:

            </th>

            <td>

                <asp:DropDownList ID="ddlCommittee" runat="server" DataSourceID="odsCommittees" DataTextField="CommitteeName"

                    DataValueField="CommitteeID" EnableViewState="true">

                </asp:DropDownList>

            </td>

        </tr>

        <tr>

            <th>

                Question:

            </th>

            <td>

                <asp:TextBox ID="txtQuestion" runat="server" Height="250px" TextMode="MultiLine"

                    Width="100%"></asp:TextBox>

                <br />

                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Please enter your question above."

                    ControlToValidate="txtQuestion" Display="Dynamic"></asp:RequiredFieldValidator>

            </td>

        </tr>

        <tr>

            <th>

                Public?

            </th>

            <td>

                <asp:CheckBox ID="cbPublic" runat="server" />

            </td>

        </tr>

        <tr>

            <td colspan="2">

                <asp:Button ID="Button1" runat="server" Text="Send" CommandName="Insert" />

            </td>

        </tr>

    </table>

    <asp:ObjectDataSource ID="odsCommittees" runat="server" FilterExpression="IsActiveCommittee=1"

        OldValuesParameterFormatString="{0}" SelectMethod="GetData" TypeName="SapaDAL.CommitteesTableAdapters.CommitteesTableAdapter">

    </asp:ObjectDataSource>

    <asp:ObjectDataSource ID="odsQuestion" runat="server" 

        InsertMethod="AskQuestion" OldValuesParameterFormatString="original_{0}" 

        SelectMethod="GetQuestionByRowGuid" TypeName="SapaDAL.QandADAL+QandA">

        <SelectParameters>

            <asp:Parameter DbType="Guid" Name="RowGuid" />

        </SelectParameters>

        <InsertParameters>

            <asp:Parameter DbType="Guid" Name="RowGuid" />

            <asp:ControlParameter ControlID="txtQuestion" Name="Question" 

                PropertyName="Text" Type="String" />

            <asp:ControlParameter ControlID="ddlCommittee" Name="CommitteeID" 

                PropertyName="SelectedValue" Type="Int32" />

            <asp:Parameter Name="Questioner" Type="Int32" />

            <asp:ControlParameter ControlID="cbPublic" Name="AllowPublic" 

                PropertyName="Checked" Type="Boolean" />

        </InsertParameters>

    </asp:ObjectDataSource>









 Private _newRowID As Guid

    Private _notificationSubject As String = "SAPA Question Submission"

    Private _notificationMsg1 As String = "Your question was successfully submitted to SAPA at " & Date.UtcNow & " UTC. You will be notified via email and the SAPA website when an answer has been submitted. Thank you for you participation."



    Private Sub Notify()

        If _newRowID <> Guid.Empty Then

            ' send to user

            Dim sbp As New SapaBasePage

            sbp.SendNotificationToCurrentUser(_notificationSubject, _notificationMsg1)

            ' send to sapa

            Dim _nh As New NotificationHelper.QandA

            _nh.SendQuestionAdminEmail(_newRowID)

        End If

    End Sub



    Protected Sub ddlCommittee_DataBound(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim cb As ASPxComboBox = CType(sender, ASPxComboBox)

        ' cb.Items.Insert(0, New ListEditItem("General SAPA Question", "0"))



        If Not (Page.IsPostBack Or Page.IsCallback) Then

            If Request.QueryString("ComID") IsNot Nothing Then

                Dim ComID As Integer = 0

                Try

                    Dim selCom As Integer = CInt(Request.QueryString("ComID"))

                    cb.SelectedIndex = cb.Items.FindByValue(selCom).Index

                Catch ex As Exception

                    ' don't log

                    cb.SelectedIndex = 0

                End Try

            Else

                cb.SelectedIndex = 0

            End If

        End If

    End Sub



    Private Sub odsQuestion_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles odsQuestion.Inserted

        If e.Exception IsNot Nothing Then

            JavaHelper.Alert.Show(e.Exception.Message)

            e.ExceptionHandled = True

        Else

            Notify()

            JavaHelper.Alert.Show("Your question was submitted to SAPA. You will be notified via email and this site when SAPA has posted an answer. Thank you for your participation.")

        End If

    End Sub



    Private Sub odsQuestion_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs) Handles odsQuestion.Inserting

        e.InputParameters("Questioner") = CurrentSapaUser.Users(0).EmpNo

        _newRowID = Guid.NewGuid

        e.InputParameters("RowGuid") = _newRowID

    End Sub



    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click

        If Page.IsValid And ddlCommittee.SelectedIndex > -1 Then

            odsQuestion.Insert()

        End If

    End Sub

Open in new window

0
Comment
Question by:dacIT
  • 4
6 Comments
 
LVL 8

Expert Comment

by:Mohit Vijay
Comment Utility
Let me assume, you have name of dropdown as ddl1, so

ddl1.selectedItem.value will give you value part and
ddl1.selectedItem.text will give you text part.
0
 
LVL 3

Expert Comment

by:vusov
Comment Utility
Use SelectedValue property. So will have this code
<asp:ControlParameter ControlID="ddlCommittee" Name="CommitteeId" 

                PropertyName="SelectedValue"  />

Open in new window

0
 
LVL 7

Author Comment

by:dacIT
Comment Utility
Thanks, but as you can see from the posted code, that's what I'm doing.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 7

Author Comment

by:dacIT
Comment Utility
Whoops. I guess my code DOESN'T have the selectedvalue in the markup, it was in there when I tested it however. I just tested again and it's sending NULL as the parameter value in the ODS even though the DDL does have a value selected. I'm stumped. This should be pretty straight forward.
0
 
LVL 7

Author Comment

by:dacIT
Comment Utility
Actually, it is in there, it's the control parameter in the ODS insert section. Still doesn't work.
0
 
LVL 7

Accepted Solution

by:
dacIT earned 0 total points
Comment Utility
Well, I figured out the problem. It was the viewstate was in fact disabled in the inherited base page. Once I reenabled it, everything worked as I would expect. Thanks for everyone's input.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now