我正在做一个项目在线会计.现在我有一个疑问. [英] I am doing a project online accounting.Now i have a doubt.

问题描述

我已经创建了gridview并绑定了数据.它包含一个包含日期和时间的字段日期.但是现在我只想绑定日期.怎么可能呢?

I have already created a gridview and bind the data .it contains a field date containing both date and time.but now i only want to bind date only .How can it possible?

推荐答案

设置此

DataFormatString="{0:dd/MM/yyyy}"

到gridview列

喜欢

to the gridview column

like

<asp:BoundField DataField="completiondate" HeaderText="CompletionDate" 
 SortExpression="completiondate" DataFormatString="{0:dd/MM/yyyy}" />

try:

try:

<asp:boundfield datafield="ColumnName" dataformatstring="{0:yyyy-MM-dd}" htmlencode="false" xmlns:asp="#unknown" />

有关更多信息，请参见:

http://www.aspdotnet-suresh.com/2011/05/how-to-set-date-format-in-gridview.html

for more refer:

http://www.aspdotnet-suresh.com/2011/05/how-to-set-date-format-in-gridview.html

在查询中，在您的选择语句，执行ff:

Modify it in your query, in your select statement, do the ff:

SELECT CAST(GETDATE() AS DATE) AS 'DateToday'

或

OR

SELECT CONVERT(varchar(10), GETDATE, 111) AS 'DateToday'

如果这解决了您的问题，请标记为答案并投票5

问候，
爱德华

Please mark as answer and vote 5 if this solved your problem

Regards,
Eduard

这篇关于我正在做一个项目在线会计.现在我有一个疑问.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！