DateTime is a structure. It cannot be null.
You can set it a known value and have your SQL interpret it as a null
(this is easiest in a stored proc).
It seems you have attempted to do this, but it didn't work.
I haven't played with the SQLDataSorce yet. I'm in the middle of
something at the moment, but I'll try to put a little demo together
for working with null dates a little later.
On 4/5/06, Floppy <[EMAIL PROTECTED]> wrote:
> I want to set it to NULL.
>
> I tried to use e.NewValue("[parametername]") = "string" on a textbox.
> It was updated into the db. When I tried it w/ the datetime with all
> of the solution ppl provided, I am getting similar errors :(
>
> :(
>
>
> On 4/5/06, Dean Fiala <[EMAIL PROTECTED]> wrote:
> > You are trying to set the DefaultValue
> >
> > on
> >
> > SqlDataSource2.UpdateParameters("actualTestResultDate").DefaultValue
> >
> > to a null or minimum value?
> >
> > ?
> >
> >
> > On 4/5/06, orangefluffybun <[EMAIL PROTECTED]> wrote:
> > > Hi, Please help. Thanks in advance!
> > >
> > > I tried all of the following. The error messages are right below each
> > > method.
> > >
> > > I think it has to do with other area of the page and codebehind. I am
> > > performing the null assignment in
> > > Protected Sub FormView1_ItemUpdating(ByVal sender As Object, ByVal e
> > > As System.Web.UI.WebControls.FormViewUpdateEventArgs)
> > Handles
> > > FormView1.ItemUpdating
> > >
> > > My default mode of FormView1 is "Edit" and it's service as a detail
> > > (editing) form of the parent (a GridView control). FormView1 is
> > > populated when the Select button is clicked on a given record in the
> > > GridView control.
> > >
> > > I even tried it w/ a textbox item in the same event, but the data
> > > never did get updated into the db! I have similar code working in
> > > another page where there is only a FormView Control and have
> > > 'SqlDataSource1.InsertParameters("createdon").DefaultValue = Date.Now'
> > > working.
> > >
> > > SqlDataSource2.UpdateParameters("updateName").DefaultValue =
> > > "xxxxxxxxxxxxxxxxxxx"
> > > Response.Write("<br>after: " &
> > > SqlDataSource2.UpdateParameters("updateName").DefaultValue)
> > >
> > > Why why why do they behave differently?
> > > '================================================
> > > 'Dim sqldatenull As SqlDateTime = SqlDateTime.Null
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > > 'Dim sqldatenull = System.DBNull.Value
> > > ':err: Conversion from type 'DBNull' to type 'String' is not valid.
> > >
> > >
> > 'SqlDataSource2.UpdateParameters("actualTestResultDate").DefaultValue
> > > = DateTime.MinValue
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > >
> > 'SqlDataSource2.UpdateParameters("actualTestResultDate").DefaultValue
> > > = Convert.ToDateTime("1/1/1900")
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > > '-----------------
> > > <asp:FormView ID="FormView1" runat="server" DataKeyNames="TaskID"
> > > DataSourceID="SqlDataSource2"
> > > DefaultMode="Edit">
> > > .....
> > > '-----------------
> > > <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>
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Dean Fiala
> > Very Practical Software, Inc
> > Now with Blogging...
> > http://www.vpsw.com/blogbaby
> >
> >
> >
> > On 4/5/06, orangefluffybun <[EMAIL PROTECTED]> wrote:
> > > Hi, Please help. Thanks in advance!
> > >
> > > I tried all of the following. The error messages are right below each
> > > method.
> > >
> > > I think it has to do with other area of the page and codebehind. I am
> > > performing the null assignment in
> > > Protected Sub FormView1_ItemUpdating(ByVal sender As Object, ByVal e
> > > As System.Web.UI.WebControls.FormViewUpdateEventArgs)
> > Handles
> > > FormView1.ItemUpdating
> > >
> > > My default mode of FormView1 is "Edit" and it's service as a detail
> > > (editing) form of the parent (a GridView control). FormView1 is
> > > populated when the Select button is clicked on a given record in the
> > > GridView control.
> > >
> > > I even tried it w/ a textbox item in the same event, but the data
> > > never did get updated into the db! I have similar code working in
> > > another page where there is only a FormView Control and have
> > > 'SqlDataSource1.InsertParameters("createdon").DefaultValue = Date.Now'
> > > working.
> > >
> > > SqlDataSource2.UpdateParameters("updateName").DefaultValue =
> > > "xxxxxxxxxxxxxxxxxxx"
> > > Response.Write("<br>after: " &
> > > SqlDataSource2.UpdateParameters("updateName").DefaultValue)
> > >
> > > Why why why do they behave differently?
> > > '================================================
> > > 'Dim sqldatenull As SqlDateTime = SqlDateTime.Null
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > > 'Dim sqldatenull = System.DBNull.Value
> > > ':err: Conversion from type 'DBNull' to type 'String' is not valid.
> > >
> > >
> > 'SqlDataSource2.UpdateParameters("actualTestResultDate").DefaultValue
> > > = DateTime.MinValue
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > >
> > 'SqlDataSource2.UpdateParameters("actualTestResultDate").DefaultValue
> > > = Convert.ToDateTime("1/1/1900")
> > > ':err: Object cannot be cast from DBNull to other types.
> > >
> > > '-----------------
> > > <asp:FormView ID="FormView1" runat="server" DataKeyNames="TaskID"
> > > DataSourceID="SqlDataSource2"
> > > DefaultMode="Edit">
> > > .....
> > > '-----------------
> > > <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>
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Dean Fiala
> > Very Practical Software, Inc
> > Now with Blogging...
> > http://www.vpsw.com/blogbaby
> >
> >
> > ________________________________
> > YAHOO! GROUPS LINKS
> >
> > Visit your group "AspNet2" on the web.
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> > ________________________________
> >
>
>
>
> 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/
