<asp:SqlDataSource ID="DSViewOvrAllUnPaidBills" runat="server"
        ConnectionString="<%$ ConnectionStrings:CHSConnectionString
%>"
        SelectCommand="UDSP_ViewOvrAllUnPaidBills"
SelectCommandType="StoredProcedure"
        UpdateCommand="UDSP_UpdateBill"
UpdateCommandType="StoredProcedure" >
        <UpdateParameters>
            <asp:Parameter Name="BillId" Type="Int64" />
            <asp:Parameter Name="ChequeNo" Type="String"
ConvertEmptyStringToNull="true" />
 
-----------------------------------------------------------------------------------------------------------------------
    <asp:Parameter Name="PaidTime" Type="DateTime" DefaultValue='<%
DateTime.Now%>'/>
 
-----------------------------------------------------------------------------------------------------------------------
        </UpdateParameters>
    </asp:SqlDataSource>

 i actually want to input the datetime as a default value to in update
parameter,if the user dont insert the date.but m unable to do in ths
maner.i realy need on urgent basis,thanks for showing ur concern.

Reply via email to