提取数据表中数据生成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 += "";
            foreach (DataColumn i in ds.Tables[0].Columns)
            {
                data += "";
                if (sh_bz.Length > 30)
                {
                    data += sh_bz.Substring(0, 30) + "...";
                }
                else
                {
                    data += sh_bz;
                }

                data += "";
            }
            data += "";
        }
        //data = data.Substring(0, data.Length - 1);
        data = "/'" + data + "
		
			
			
				
				
					
					
						物料编码
					

					
						单位
					

				

			

		
/'";
        Response.Write(data);
    }
}