提取数据表中数据生成html

来源：互联网发布：coredata删除所有数据编辑：程序博客网时间：2024/06/07 18:38

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