<div class="j_rt2">
<b>{position}</b>
<div class="j_rt2_txt">岗位职责：{duties}
</div>
</div>
我想循环生成这段代码怎么弄啊！现在生成的是数据库中最后一条
cs文件如下：
//这个是一个按钮事件——生成静态页
protected void html_button_Click(object sender, EventArgs e)
{
string selete = "select position,duties from news where title='招聘信息'";
SqlDataAdapter da = new SqlDataAdapter(selete, sqlconn);
DataSet ds = new DataSet();
da.Fill(ds);
string position = ds.Tables[0].Rows[0][0].ToString();
string duties = ds.Tables[0].Rows[0][1].ToString();
StringBuilder strHtml = new StringBuilder();
for (int i = 0; i <= ds.Tables[0].Rows.Count; i++)
{
OutputHtml(position, duties);
}
}
private void OutputHtml(string position, string duties)
{
string FName = "job.htm";
string HtmlPath = String.Format(@"/HtmlLink/{0}", FName);
string HtmlTemp = File.ReadAllText(Server.MapPath("/HtmlTemp/job.htm"), Encoding.UTF8);
StringBuilder SBuilder = new StringBuilder(HtmlTemp);
SBuilder.Replace("{position}", position);
SBuilder.Replace("{duties}", duties);
StreamWriter SWriter = File.CreateText(Server.MapPath("/HtmlLink/") + FName);
SWriter.WriteLine(SBuilder.ToString());
SWriter.Flush();
SWriter.Close();
}
------解决方案--------------------
把这段代码封装成一个方法，在button_Click事件中循环调用该方法！
------解决方案--------------------
你的stream打开关闭位置不要放到循环体内
代码修改了下，如下：
- C# code
protected void html_button_Click(object sender, EventArgs e) { string selete = "select position,duties from news where title='招聘信息'"; SqlDataAdapter da = new SqlDataAdapter(selete, sqlconn); DataSet ds = new DataSet(); da.Fill(ds); string position = ds.Tables[0].Rows[0][0].ToString(); string duties = ds.Tables[0].Rows[0][1].ToString(); StringBuilder strHtml = new StringBuilder(); StreamWriter SWriter = File.CreateText(Server.MapPath("/HtmlLink/") + FName);//在写到stream前就打开 for (int i = 0; i <= ds.Tables[0].Rows.Count; i++) { OutputHtml(position, duties); } //全部写完之后再关闭stream SWriter.Flush(); SWriter.Close(); } private void OutputHtml(string position, string duties) { string FName = "job.htm"; string HtmlPath = String.Format(@"/HtmlLink/{0}", FName); string HtmlTemp = File.ReadAllText(Server.MapPath("/HtmlTemp/job.htm"), Encoding.UTF8); StringBuilder SBuilder = new StringBuilder(HtmlTemp); SBuilder.Replace("{position}", position); SBuilder.Replace("{duties}", duties); SWriter.WriteLine(SBuilder.ToString()); }