I have a textbox where I need to display database minimum date and time using stored procedure.
Here is my stored procedure:
ALTER PROCEDURE [dbo].[usp_GetMinDate]
(@pID Int)
AS
BEGIN
SELECT
min(DATE_COLUMN)
FROM
TABLE_1
WHERE ID = @pID
END
Here is my TextBox entry:
<asp:TextBox ID="IntMinDate" runat="server" Text='<%#Eval("IntMinDate")%>' Width="381px" ReadOnly="true" CssClass="readOnly"></asp:TextBox>
Here is what I am working on under sqldatareader (code behind).
cmd = connector.GetCommand("usp_GetMinDate"); cmd.Parameters.Add(new SqlParameter("@pID", SqlDbType.Int)).Value = IntMinDate;
Can someone please provide me with some direction or guidance on how to be able to show a single datetime value into a text box using S ...
Go to the complete details ...