页面代码如下:
' border="0" > 后台代码:SqlConnection con=new SqlConnection (ConfigurationSettings.AppSettings ["strconn"]);con.Open ();SqlCommand cmd=new SqlCommand ("select id,Title,datediff(day,sendDate,getdate()) as DayCount from NewInfo",con);SqlDataAdapter da=new SqlDataAdapter(cmd);DataSet ds=new DataSet ();da.Fill (ds);con.Close ();myGrid1.DataBind();//sendDate是一个DateTime类型的字段,是指发布日期