提取数据表中数据生成html

1.在做办公自动化的时候,通常会遇到这样的问题,需要从数据库中提取数据.生成html语句
2.发送htm到邮件中去

public static DataSet GetDataSet(string strCommandString, string strTableName)//取得ds { Open(); SqlDataAdapter adAdapter = new SqlDataAdapter(); adAdapter.SelectCommand = new SqlCommand(strCommandString, MyConnection); DataSet dsDataSet = new DataSet(); dsDataSet.Clear(); adAdapter.Fill(dsDataSet, strTableName); return dsDataSet; } using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class testhtm : System.Web.UI.Page { public static string data = string.Empty; protected void Page_Load(object sender, EventArgs e) { string strsql="select top 10 item,u_m from item"; string strtable="item"; html(DataAccess.DABaseAccess.GetDataSet(strsql, strtable)); } protected void html(DataSet ds) //生成html { foreach (DataRow j in ds.Tables[0].Rows) { string sh_bz = string.Empty; data += "<tr>"; foreach (DataColumn i in ds.Tables[0].Columns) { data += "<td "; //data += i.ColumnName.ToString().Replace("/'", "//'").Trim(); //data += ":"; sh_bz = j[i].ToString().Replace("'", "//'").Trim(); data += " title=/"" + sh_bz + "/" >"; if (sh_bz.Length > 30) { data += sh_bz.Substring(0, 30) + "..."; } else { data += sh_bz; } data += "</td>"; } data += "</tr>"; } //data = data.Substring(0, data.Length - 1); data = "/'<table cellpadding=/"0/" cellspacing=/"0/"><tr ><td class=/"li_1/">物料编码</td><td class=/"li_2/">单位</td></tr>" + data + "</table>/'"; Response.Write(data); } }