gridview问题,日期问题 [英] gridview problem, date issues
问题描述
我将gridview设置为DataFormatString ={0:dd / MM / yyyy},但在搜索我的gridview后变为dd / MM / yyyy和12:00 AM,如何解决这个问题?
我将我的日期声明为字符串,并在我的数据库中存储为Date,这是我在我的datareader中声明的方式dateFrom = Convert.ToDateTime(dr [DateFrom])。ToString(dd / MM / yyyy); ,这是comaand cmd.Parameters.AddWithValue(@ DateFrom,_ dateFrom);
I set my gridview as DataFormatString="{0:dd/MM/yyyy}", but after searching my gridview become dd/MM/yyyy and 12:00AM , how to fix this?
I declare my date as string and in my db is store as Date, this is my how I declare in my datareader dateFrom = Convert.ToDateTime(dr["DateFrom"]).ToString("dd/MM/yyyy");, and this is comaand cmd.Parameters.AddWithValue("@DateFrom", _dateFrom);
推荐答案
在您的数据库中保存带时间戳的日期。喜欢这种类型的Design
In your data base save Date with time stamp. like this type of Design
datetime2(7)
datetime2(7)
,更改数据库(表格列)设计)。日期格式(日期)的设置。
转换为日期格式后,您的问题可能已解决。
, change in your database (Table column Design ). set of Date format (Date).
It may be your problem has been solve after convert to Date format.
这篇关于gridview问题,日期问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!