Solved

ObjectDataSource retrieving column value

Posted on 2009-07-16
2
648 Views
Last Modified: 2012-05-07
Hi Guys,

I'm new to ASP.NET and wondering what the problem is with the following code. - see below. Basically what I have got is a FormView control which is getting it's data from a ObjectDataSource control. This all works fine. The ObjectDataSource uses a different source of data depending on the querystring (LocalPartnerID=...)

Now on my page load event, I call the method FindTypeEdit() in order to the value of one of my columns "Type" that has comma separated values like: Government, Non Government, International and pass it as a string to a method that will check if these selections are on the TypeCheckBoxList items choices to display them.

I'm using ObjectDataSource1.selectedparameters in hopes of accessing the values but well being not so familiar with ADO.NET I'm failing to select anything.
Please see below for my code

Many thanks in advance for your help!
Jeewai

ObjectDataSOurce connected to FormView:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}"     SelectMethod="GetDataLocalPartners"              TypeName="ICRSDataSetTableAdapters.tblLocalPartnerTableAdapter"
              UpdateMethod="Update">
              <DeleteParameters><asp:Parameter Name="Original_LocalPartnerID" Type="Byte" />
              </DeleteParameters>
              <UpdateParameters>   ...   </UpdateParameters>
              <SelectParameters> <asp:QueryStringParameter Name="LocalPartnerID"
                      QueryStringField="LocalPartnerID" Type="Byte" /> </SelectParameters>
              <InsertParameters>   ...    </InsertParameters>
          </asp:ObjectDataSource>
Public Sub FindTypeEdit()

        Dim TypeCheckBoxListEdit As CheckBoxList = CType(FormView1.FindControl("Tabcontainer1").FindControl("TabPanel1").FindControl("TypeCheckBoxListEdit"), CheckBoxList)

        'This was as a trial - hardcoded string of items -,representing possible values for the

        'column "Type" . This was to ensure that checkboxList items are passed and display ok

        'on CheckBoxList. 'Dim preferences As String = "Government,Non Government,International"
 

        'Now, in my real life senario, I need to get the value of column "Type"

        'and pass it as a string. This is where I fail.

        ObjectDataSource1.SelectParameters("Type").DefaultValue ' not working

        Dim preferences As String = ?????
 

        'The rest below works perfectly well provided I get string variables in my preference string

        Dim li As ListItem

        Dim preference() As String = preferences.Split(",")

        'Clear any previous setting

        TypeCheckBoxListEdit.SelectedIndex = -1

        For Each pref As String In preference

            li = TypeCheckBoxListEdit.Items.FindByValue(pref)

            If li Is Nothing = False Then

                li.Selected = True

            End If

        Next

    End Sub

Open in new window

0
Comment
Question by:jeewai
2 Comments
 
LVL 41

Assisted Solution

by:guru_sami
guru_sami earned 200 total points
ID: 24879196
ObjectDataSource1.SelectParameters("Type").DefaultValue ' not working
Now Your ObjectDataSource1 does not have any Paramert Name "Type"..it has only one parameter defined:
<asp:QueryStringParameter Name="LocalPartnerID" QueryStringField="LocalPartnerID" Type="Byte" />

So I am not sure what you are trying to do....not getting any clear idea what is the exact problem.
0
 

Accepted Solution

by:
jeewai earned 0 total points
ID: 24885990
Thanks Guru_Sami for your comments,

Sorry for not being so clear in my post. What I wanted was simply to retrieve data from a certain column and pass it as a string. I have searched additional help in other forums and found out what to do:
create a hidden field inside my formview that is bound to that specific column,.. and simply pass the retrieved value as a string..

Jeewai

<asp:TextBox ID="HidTypeTextBoxEdit" runat="server" Visible="False" Text='<%# Bind("Type") %>'></asp:TextBox>




Public Sub FindTypeEdit()

Dim TypeCheckBoxListEdit As CheckBoxList = CType(FormView1.FindControl("Tabcontainer1").FindControl("TabPanel1").FindControl("TypeCheckBoxListEdit"), CheckBoxList)

'Get values from Hidden Type textField 

Dim HidTypeTextBoxEdit As TextBox = CType(FormView1.FindControl("Tabcontainer1").FindControl("TabPanel1").FindControl("HidTypeTextBoxEdit"), TextBox)

Dim preferences As String = HidTypeTextBoxEdit.Text

Dim li As ListItem

Dim preference() As String = preferences.Split(",")

'Clear any previous setting 

TypeCheckBoxListEdit.SelectedIndex = -1

li = TypeCheckBoxListEdit.Items.FindByValue(pref)

For Each pref As String In preferenceIf li Is Nothing = False Then 

li.Selected = True 

End If 

Next 

End Sub

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

929 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