Did you try ...
ISNULL( @ActualTestResultDate, NULL)
?
tom mallard
.net web applications
industrial design
----- Original Message -----
From: Floppy<mailto:[EMAIL PROTECTED]>
To: [email protected]<mailto:[email protected]>
Sent: Wednesday, April 05, 2006 7:09 PM
Subject: Re: [AspNet2] SqlDataSource UpdateParameters Trouble! Please
help.......
I used a stored procedure as follows.
@ActualTestResultDate DateTime = NULL (if I remember correctly). It
doesn't seem to do anything.
* off this topic *
btw, I was trying to concatenate all data using Select [field1] +
[field2] as LongString where.... When one of the fields has NULL
returned LongString's value becomes NULL. I tried Set
Concat_NULL_to_NULL On (if I remember correctly) in a SP along w/ the
select statement, it doesn't seem to do anything either.
On 4/5/06, Dean Fiala <[EMAIL PROTECTED]> wrote:
> 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<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<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<http://www.vpsw.com/blogbaby>
>
>
>
>
>
> 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<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<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<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
a.. Visit your group "AspNet2<http://groups.yahoo.com/group/AspNet2>" on
the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service<http://docs.yahoo.com/info/terms/>.
------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
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/
