网格视图中的日期类型 [英] date type in grid view

问题描述

我将农业视图绑定为

i have bound agrid view as

var query3 = from p in _zentity.Tbl_Employer_History
                             join r in _zentity.Tbl_Industry
                            on p.industry_id equals r.industry_id
                             where p.member_id == memberId
                             select new { p.employer_name, p.industry_id, p.designation, p.worked_from , p.worked_to ,p.responsibilities };
                gvw.DataSource = query3;
                gvw.DataBind();

现在我只想要工作的开始日期和工作时间，而不是时间.
我该怎么办
请尽快帮助我.

now i want only date of Work from and Work to ,not time.
what can i do
please help me soon.

推荐答案

您需要将格式应用于datetime字段.
试试这个:

You need to apply formatting to the datetime field.
Try this:

var query3 = from p in _zentity.Tbl_Employer_History
                             join r in _zentity.Tbl_Industry
                             on p.industry_id equals r.industry_id
                             where p.member_id == memberId
                             select new
                             {
                               p.employer_name, p.industry_id, p.designation,             
                               p.worked_from.ToString("dd-MM-yyyy"), 
                               p.worked_to.ToString("dd-MM-yyyy"),p.responsibilities 
                             };
gvw.DataSource = query3;
gvw.DataBind();

--Amit

--Amit

嗨
请检查以下网址:

http://social.msdn.microsoft.com /Forums/zh-CN/csharpgeneral/thread/5073cf4b-3b66-4cab-92ca-08ed0f3bd828/ [

Hi
Please check the below url:

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/5073cf4b-3b66-4cab-92ca-08ed0f3bd828/[^]

这篇关于网格视图中的日期类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！