Question #1:
Null and blank are not equivalent. What you'll want to do is either
use a COALESCE function in the SP to spit out a blank (empty string
'') value, or do custom databinding in the Databound event and simply
set the Selected Index of the ddl = 0 when a null value is found.
Question #2:
See my previously reply.
On 4/3/06, orangefluffybun <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Question #1:
>
> To add a blank value at the top of a dropdownlist, I am loading data
> into it in my FormView1_DataBound.
>
> It keeps giving me an error:
> System.ArgumentOutOfRangeException: 'ddlApprovers' has a
> SelectedValue which is invalid because it does not exist in the list
> of items.
> Parameter name: value
>
> I know the value being returned is definitely Null. Please help.
> Thanks!!!
>
> Question #2:
> Is there a way to retrieve the field in code in a sqlDataSource? If
> I could do it, then I could write it out and maybe use the following
> line to set the selected value?
> ddlApprovers.Items.FindByText([sqlDatasource2.......?]).Selected =
> True
>
>
>
> <asp:DropDownList ID="ddlApprovers" runat="server"
> selectedValue='<%# Bind("certby") %>'> <asp:SqlDataSource
> ID="SqlDataSource2" runat="server" ConnectionString="<%$
> ConnectionStrings:aSysConnectionString %>"
> SelectCommand="sp_oneTaskRec"
> SelectCommandType="storedProcedure"
> DeleteCommand="DELETE FROM [tblTasks] WHERE [TaskID] =
> @TaskID" UpdateCommand="UPDATE [tblTasks] SET
> [updateName] = @updateName, [testNeeded] = @testNeeded,
> [testDuration] = @testDuration, [Result] = @Result, [testPlan] =
> @testPlan, [backoutPlan] = @backoutPlan, [comment] = @comment,
> [opDate] = @opDate, [opTime] = @opTime, [testResultDueDate] =
> @testResultDueDate, [testResultDueTime] = @testResultDueTime,
> [testResultComment] = @testResultComment, [actualTestResultDate] =
> @actualTestResultDate, [actualTestResultTime] =
> @actualTestResultTime, [certBy] = @certBy, [certOn] = @certOn,
> [opID] = @opID WHERE [TaskID] = @TaskID" >
> <DeleteParameters> <asp:Parameter Name="TaskID"
> Type="Int32" /> </DeleteParameters>
> <SelectParameters> <asp:ControlParameter
> ControlID="GridView1" Name="TaskID" PropertyName="SelectedValue"
> type="Int32"/> </SelectParameters>
> <UpdateParameters> <asp:Parameter Name="updateName"
> Type="String" /> <asp:Parameter Name="testNeeded"
> Type="Boolean" /> <asp:Parameter Name="testDuration"
> Type="Int32" /> <asp:Parameter Name="Result"
> Type="Int32" /> <asp:Parameter Name="testPlan"
> Type="String" /> <asp:Parameter Name="backoutPlan"
> Type="String" /> <asp:Parameter Name="comment"
> Type="String" /> <asp:Parameter Name="opDate"
> Type="DateTime" /> <asp:Parameter Name="opTime"
> Type="DateTime" /> <asp:Parameter
> Name="testResultDueDate" Type="DateTime" />
> <asp:Parameter Name="testResultDueTime"
> Type="DateTime" /> <asp:Parameter
> Name="testResultComment" Type="String" />
> <asp:Parameter Name="actualTestResultDate"
> Type="DateTime" /> <asp:Parameter
> Name="actualTestResultTime" Type="DateTime" />
> <asp:Parameter Name="certBy" Type="Int32"
> ConvertEmptyStringToNull="true" /> <asp:Parameter
> Name="certOn" Type="DateTime" /> <asp:Parameter
> Name="opID" Type="Int32" /> <asp:Parameter
> Name="TaskID" Type="Int32" />
> </UpdateParameters> </asp:SqlDataSource> '-------------------
> ------ Protected Sub FormView1_DataBound(ByVal sender As Object,
> ByVal e As System.EventArgs) Handles FormView1.DataBound
> GetApproverList() End Sub Sub GetApproverList
> () '===== works ====== Dim myconnection As New
> SqlConnection(ConnString) myconnection.Open() Dim
> strSQL As String = "SELECT uID, uName FROM tblUsers where
> ApprovalRight = 1 ORDER BY uName" Dim objCommand As New
> SqlCommand(strSQL, myconnection) Dim objDataReader As
> SqlDataReader = objCommand.ExecuteReader
> (CommandBehavior.CloseConnection) Response.Write
> ("hello") Dim ddlApprovers As
> System.Web.UI.WebControls.DropDownList ddlApprovers =
> FormView1.FindControl("ddlApprovers")
> ddlApprovers.DataSource = objDataReader
> ddlApprovers.DataTextField = "uName"
> ddlApprovers.DataValueField = "uid" ddlApprovers.DataBind
> () ddlApprovers.Items.Insert(0, "") 'Response.Write
> (Data.Sq.DefaultValue) 'ddlApprovers.SelectedValue
> = "certBy" 'SqlDataSource2.SelectParameters
> ("certby").DefaultValue 'ddlApprovers.Items.FindByText
> ("").Selected = True 'Response.Write(strSQL & "<br>" &
> objDataReader.HasRows) objDataReader.Close()
> objDataReader = Nothing myconnection.Close() End Sub
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
Now with Blogging...
http://www.vpsw.com/blogbaby
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNet2/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
