小颖传奇1.76特色服

散人公益,自由交易,

   ::  ::  ::  ::  :: 管理

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();
    }

posted on 2009-04-18 10:35  xymir  阅读(164)  评论(0)    收藏  举报