我的时间字段(下例中tim字段)的格式为2007-9-14 11:47:00和2007-9-12两种,我想取月份和日期.如:09-14和09-12后台将数据绑定到gridview上.代码如下:string sql_en = "select top 8 id,topic,tim from......";
SqlCommand cmd_en = new SqlCommand(sql_en, mycon.conn);
SqlDataAdapter da_en = new SqlDataAdapter();
da_en.SelectCommand = cmd_en;
DataSet ds_en = new DataSet();
da_en.Fill(ds_en);
GridView1.DataSource = ds_en;
GridView1.DataBind();
前面代码<%# DataBinder.Eval(Container.DataItem,"tim")%>现在前台提出的时间是2007-9-14 11:47:00或2007-9-12.我想显示为09-14或09-12请问该如何实现啊?
SqlCommand cmd_en = new SqlCommand(sql_en, mycon.conn);
SqlDataAdapter da_en = new SqlDataAdapter();
da_en.SelectCommand = cmd_en;
DataSet ds_en = new DataSet();
da_en.Fill(ds_en);
GridView1.DataSource = ds_en;
GridView1.DataBind();
前面代码<%# DataBinder.Eval(Container.DataItem,"tim")%>现在前台提出的时间是2007-9-14 11:47:00或2007-9-12.我想显示为09-14或09-12请问该如何实现啊?
<%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem,"tim").ToString()).ToString("MM-dd")%>