dropdown list in a formview

did you use something like this in your dropdownlist

SelectedValue='<%# Bind("yesornofield") %>'


make sure yesornofield has default value so it always has a value to select on load!

hope that makes sense..

the way i do n-tier apps at moment or as i understand is, the most data manipulation is done in business layer using pre populated business objects/collections and then passed/used in the presentation layer. each layer makes calls to previous layer only, i.e.

data -- Data Access
Data Access -- Bus Layer
Bus Layer - Presentation layer

thus your app will be platform independent, i.e. if you want to change from winform to webform you only need to modify the presentation layer, or database you only change DAL layer etc..

it will be great to get views of other experts on this.

abs

^

please ignore my last post, i posted it on the wrong questions


sorry!

Yes i have the SelectedValue='<%# Bind("yesornofield") %>' in my case the name of my field is "followup".  This field on my database is set to null... is that what you mean by...."make sure yesornofield has default value so it always has a value to select on load!"

yep thats what i mean...

so i should put a defalult value in my database table colum?

Hi experts,
I could really use the help with this problem. I looked at previous question like this one and they are all without an aswer I could use.

Thanks,

hey bud, did you try my suggestion?!

I guess I don't understand what you mean... do I need to put a value of "Yes" or "No" in my database table as a default?

thanks,

Hi,
It's given me the same error....

==========================================================================
'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
==========================================================================

This is my drop down lit
<EditItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind("permits") %>' DataTextField="NO" DataValueField="0">
                            <asp:ListItem Selected="True" Value="1">Yes</asp:ListItem>
                            <asp:ListItem Value="2">No</asp:ListItem>
                        </asp:DropDownList>

                    </EditItemTemplate>

Thanks,

as i said earlier <%# Bind("permits") %> should be 1 or 2 at all time,  therefore check permits column if it contains values other than 1 or 2...

Hi here4u247,
I'm actually embarrased to tell you that I am still getting the same error. I am missing what you mean by
===============================================================================
as i said earlier <%# Bind("permits") %> should be 1 or 2 at all time,  therefore check permits column if it contains values other than 1 or 2...
================================================================================
Did you mean check the permit column in my database? I did that, i put a default value of 1... and that didn't work... I get the same error
Where exactly do I check for the <%#Bind("permits")%> value to make sure is set for 1 or 2?
Thank you for all your help!

thats no prob vthunder70, so the permits column is defaulted to value of 1, which is good, so it could be data issue, so check in permits column if any row has any value other than 1/2, you can do that by querying the db, i.e.:

select * from [TABLENAME] where permits <> 1 or permits <> 2

and see if it brings any results...


cheers,

abdi

Hi Abdi,
Thanks for your help and your time!
I delete the column and added it again I use the default value = 1 and it worked!! then I went one step further and change my data type to vchar and wrote default value = NO and change my values in my dropdownlist and IT WORKED TOO!!!

thanks again