The page code is as follows:
Cellpadding = "0" autogeneratecolumns = "false" height = "100%" width = "224px" runat = "server">
itemStyle>
DataTextField = "Title"> asp: hyperlinkcolumn>
Itemtemplate>
asp: templateColumn>
Columns>
PagersTyle>
ask: DataGrid>
Backstage code:
SqlConnection Con = New SqlConnection (ConfigurationSettings.AppSettings ["strconn"]);
C.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);
C. close ();
MyGrid1.databind ();
// sendDate is a field of a DateTime type means a release date