u can set a default value for datetime of ur's table in ur'sdatabase simply
On Sat, Dec 27, 2008 at 12:30 PM, m...@ni <[email protected]> wrote: > > <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. >
