装载页面获得dataset的内容

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //调用CommonClass类中的GetDataSet获取数据集
            DataSet ds = CC.GetDataSet("select * from tb_News where id='" + Request.QueryString["id"] + "'", "tbNews");
            DataRow[] row = ds.Tables["tbNews"].Select();
            foreach (DataRow rs in row)
            {
                //显示编辑的新闻类别名
                this.txtNewsTitle.Text = rs["title"].ToString();
                //显示编辑的新闻内容
                this.txtNewsContent.Text = rs["content"].ToString();
                //显示编辑的新闻标题
                this.labTitle.Text = rs["Style"].ToString();
                //显示编辑的新闻类型
                switch (rs["type"].ToString())
                {
                    case "国内新闻":
                        this.ddlNewsType.SelectedIndex =1;
                        break;
                    case "国际新闻":
                        this.ddlNewsType.SelectedIndex =0;
                        break;
                    default:
                        break;
                }
            }
        }
    }
posted on 2009-11-14 21:56  晴天1848  阅读(216)  评论(0)    收藏  举报