提取数据表中数据生成html_抓取数据库所有的表结构数据转成html-优快云博客

本文链接：https://blog.youkuaiyun.com/david_520042/article/details/3885459

本文介绍了一种从数据库中提取数据并将其转换为HTML格式的方法，以便于通过电子邮件发送。具体步骤包括使用SQLDataAdapter填充DataSet，遍历数据行和列来构建HTML表格，并在页面加载时显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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