ASP怎么控制label取时间值只截取年月日
这是我的代码:
public partial class User_hebao_info : System.Web.UI.Page
{
SqlConnection mycon = new SqlConnection(sqlHelp.strConn);
protected void Page_Load(object sender, EventArgs e)
{
mycon.Open();
int ID=Int32.Parse(Request.QueryString["ID"].ToString());
string query = "select * from funds where ID=" + ID;
SqlCommand mycom = new SqlCommand(query, mycon);
SqlDataReader dr = mycom.ExecuteReader();
while (dr.Read())
{
Label1.Text = dr["FirstProjectName"].ToString();
Label2.Text = dr["SecondProjectName"].ToString();
Label3.Text = dr["ThridProjectName"].ToString();
Label4.Text = dr["recoupecontent"].ToString();
Label5.Text = dr["recoupetime"].ToString();
}
}
label5是获取时间的,怎么空控制显示年月日,我这样取得到label5.Text=年月日时分秒