应显示gridview日期 [英] in gridview date should be displayed

问题描述

我在数据库中插入了所有记录。



i有一个按钮视图。当我点击该按钮时，所有记录都应显示在网格视图中。 />


网格视图按钮查询如下;

 sql =  选择名称，DOB，Mobileno，Weddingday，来自BIrthDayWish的电子邮件，其中Active ='A'ORDER BY Name; 
 Dr = SCon.ReadSql（Sql）; 
 GridView1.DataSource = Dr; 
 GridView1.DataBind（）; 
 GridView1.Visible =  true ; 

网格视图中的
输出如下



姓名DOB手机没有结婚日电子邮件

ram 22/12/1986 12:00:00 AM 9945598565 22/12/2009 12:00:00 AM [e-mail]





但我希望网格视图中与DOB和婚礼日相关的输出显示为



姓名DOB手机没有结婚日电子邮件

ram 22/12/1986 9945598565 22/12/2009 [e-mail]



不需要一个

DOB婚礼当天

12:00:00 AM 12:00:00 AM

 sql =  选择名称，DOB，Mobileno，Weddingday，Email from BIrthDayWish，其中Active ='A'
 ORDER BY Name; 

来自我上面的查询如何更正查询并得到outputvvas如下

名称DOB手机没有婚礼日电子邮件

ram 22/12/1986 9945598565 22/12/2009 [e-mail]

解决方案

 <   asp：BoundField     HeaderText   =  DOB    DataField   =  DOB      DataFormatString   =  {0：dd / MM / yyyy} >  

查看以下链接更多信息邮件：

http://www.codedigest.com/Articles/ASPNET/137_How_to_format_DateTime_in_GridView_BoundColumn_and_TemplateColumn。 aspx [ ^ ]

试试这个：

  SELECT  
名称，
  CONVERT （ varchar ，DOB， 103 ） AS  DateOfBirth，
 Mobileno，
  CONVERT （ varchar ，Weddingday， 103 ） AS  WeddingDay，
电子邮件
  FROM  BIrthDayWish 
  WHERE  Active = '  A' 
  ORDER   BY 名称

i inserted all the record in the database.

i have one button view.when i click that button all record should be displayed in the Grid View.

Grid view Button Query as follows;

sql ="select Name,DOB,Mobileno,Weddingday,Email from BIrthDayWish where Active ='A' ORDER BY Name";
        Dr = SCon.ReadSql(Sql);
        GridView1.DataSource = Dr;
        GridView1.DataBind();
        GridView1.Visible = true;

output in Grid View as follows

Name DOB Mobile no Wedding day Email
ram 22/12/1986 12:00:00 AM 9945598565 22/12/2009 12:00:00 AM [e-mail]


but i want the output in grid view related to DOB and Wedding day date to be shown as

Name DOB Mobile no Wedding day Email
ram 22/12/1986 9945598565 22/12/2009 [e-mail]

Not needed a
DOB Wedding Day
12:00:00 AM 12:00:00 AM

sql ="select Name,DOB,Mobileno,Weddingday,Email from BIrthDayWish where Active ='A' 
ORDER BY Name";

from my above query how to correct the query and get the outputvvas follows
Name DOB Mobile no Wedding day Email
ram 22/12/1986 9945598565 22/12/2009 [e-mail]

解决方案

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

Check following link for more information:
http://www.codedigest.com/Articles/ASPNET/137_How_to_format_DateTime_in_GridView_BoundColumn_and_TemplateColumn.aspx[^]

Try this:

SELECT 
Name, 
CONVERT(varchar, DOB, 103) AS DateOfBirth, 
Mobileno, 
CONVERT(varchar, Weddingday, 103) AS WeddingDay, 
Email 
FROM BIrthDayWish 
WHERE Active ='A' 
ORDER BY Name

这篇关于应显示gridview日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！