怎么样从数据库中取出数据放入模板呢？请高手指点！急！！！！

Question

这个模板中很多数据要从数据库中取，我用{$uname}代替用户名，通过模板生成静态页面并把数据库中的数据显示出来
该怎么做呢？请高手指点！！

Answer 1

我也是这样做的，可是为啥没有替换掉呢？我把代码贴出来给大家看看，帮我指指错！！protected void Button2_Click(object sender, EventArgs e)
    {
        WebClient myWebClient = new WebClient();
        Stream myStream = myWebClient.OpenRead("e:/moban.html");
        StreamReader sr = new StreamReader(myStream,System.Text.Encoding.GetEncoding("gb2312"));
        string strHtml = sr.ReadToEnd();
        StreamWriter sw;
        sw = File.CreateText(Server.MapPath("html/news.htm"));
        string sql = string.Format("select * from meban");
        DataTable dt = dal.dao.getTable(sql);
        dt.PrimaryKey = new DataColumn[] { dt.Columns["id"] };//设置 主键
        DataRow dr = dt.Rows[0];
        
        strHtml.Replace("{$id}", dr["id"].ToString());
        strHtml.Replace("{$data}", dr["times"].ToString());
        strHtml.Replace("{$uname}", dr["uname"].ToString());
        strHtml.Replace("{$xueli}", dr["xueli"].ToString());
        strHtml.Replace("{$zhuanye}", dr["zhuanye"].ToString());        strHtml.Replace("{$school}", dr["school"].ToString());
        strHtml.Replace("{$years}", dr["years"].ToString());
        strHtml.Replace("{$name}", dr["relname"].ToString());
        strHtml.Replace("{$sex}", dr["sex"].ToString());        strHtml.Replace("{$shengao}", dr["shengao"].ToString());
        strHtml.Replace("{$minzu}", dr["minzu"].ToString());
        strHtml.Replace("{$age}", dr["age"].ToString());
        strHtml.Replace("{$english}", dr["english"].ToString());        strHtml.Replace("{$state}", dr["state"].ToString());
        strHtml.Replace("{$computer}", dr["computer"].ToString());
        strHtml.Replace("{$huji}", dr["huji"].ToString());
        strHtml.Replace("{$chinese}", dr["chinese"].ToString());        strHtml.Replace("{$address}", dr["address"].ToString());
        strHtml.Replace("{$tele}", dr["tel"].ToString());
        strHtml.Replace("{$pingjia}", dr["pingjia"].ToString());
        strHtml.Replace("{$fangxiang}", dr["fangxiang"].ToString());        strHtml.Replace("{$jobs}", dr["jobs"].ToString());
        strHtml.Replace("{$jobsaddress}", dr["jobsaddress"].ToString());
        strHtml.Replace("{$daiyu}", dr["daiyu"].ToString());
        strHtml.Replace("{$daogang}", dr["daogangdata"].ToString());        strHtml.Replace("{$jobdata}", dr["jobdata"].ToString());
        strHtml.Replace("{$techang}", dr["techang"].ToString());
        strHtml.Replace("{$jiaoyu}", dr["jiaoyu"].ToString());
        
        sw.WriteLine(strHtml);
            
        sw.Close();
        myStream.Close();
        
    }