页面代码如下:
CellPadding="0" AutoGenerateColumns="False" Height="100%" Width="224px" runat="server">
DataTextField="Title">
后台代码:
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类型的字段,是指发布日期

