DataTable dt = new DataTable();
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sb.ToString(), conn);
da.Fill(dt);
//创建DataGrid对象
DataGrid dg = new DataGrid();
dg.AllowPaging = false;
dg.ShowFooter = false;
dg.AutoGenerateColumns = false;
BoundColumn bc;
HyperLinkColumn hlc;
//给DataGrid添加标题列
hlc = new HyperLinkColumn();
hlc.HeaderText = "标题";
hlc.DataTextField = "title";
hlc.DataNavigateUrlField = "id";
hlc.DataNavigateUrlFormatString = "showInfo.aspx?id={0}";
hlc.ItemStyle.Width = Unit.Pixel(400); //设定标题列的宽度
hlc.Target = "_blank";
dg.Columns.Add(hlc);
//给DataGrid添加时间列
bc = new BoundColumn();
bc.HeaderText = "发表时间";
bc.ItemStyle.Width = Unit.Pixel(140);
bc.DataField = "date";
dg.Columns.Add(bc);
//将数据源绑定到DataGrid对象
dg.DataSource = dt;
dg.DataBind();
//将数据提交到页面
// Response.Write(this.GetStringByControl(dg))
public string GetStringByControl(System.Web.UI.Control c)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter writer = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(writer);
c.RenderControl(htw);
return sb.ToString();
}
浙公网安备 33010602011771号