当我在文本框中选择日期时，它将在网格视图中显示该日期的数据库 [英] when i select the date in textbox, it will show the database of that date in grid view

问题描述

嗨 我在default.aspx中添加了一个文本框，按钮，日历和网格视图.如果单击按钮，它将显示日历，当我单击日历中的日期时，日期将显示在文本框中.现在数据库位于oracle中，它具有表cgl2的字段创建.creation字段保存所有条目的日期.
当日期显示在文本框中时，它将在网格视图中显示该日期的所有条目.

解决方案

您的问题不清楚，

据我了解，您正在尝试读取数据库Datetime.

请参阅以下查询，这可能对您有帮助

SELECT TO_CHAR
    (SYSDATE, ''MM-DD-YYYY HH24:MI:SS'') "NOW"
     FROM DUAL;

谢谢
--RA

Featch the data from the database 
with in the calender  date selection event when you are binding selected date with the text box..

hi i add a textbox,button,calender and grid view in default.aspx.if i click the button it display the calender and when i click the date in calender,the date will show in the text box.now the database is in the oracle,and it has the field creation of table cgl2.The creation field saves the date of the all entries.
When the date is show in the text box,it will show the all entrie of that date in grid view.

解决方案

You Question is not clear,

As per my understand you are trying to read the database Datetime.

see the below Query this may helps you

SELECT TO_CHAR
    (SYSDATE, ''MM-DD-YYYY HH24:MI:SS'') "NOW"
     FROM DUAL;

Thanks
--RA

Featch the data from the database 
with in the calender  date selection event when you are binding selected date with the text box..

这篇关于当我在文本框中选择日期时，它将在网格视图中显示该日期的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！