张
using System;
using System.Data;
using System.Conguration;
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;
using System.Data;
using System.Text;
public partial class Default2 : System.Web.UI.Page
{
public static string Htmlhead = "<table style='border-style:solid' width='400'
align='center' border='1px' > <tr align='center'><td >主管</td><td >部门</td><td >厂
区</td><td >人数</td></tr>";
public static string htmlfoot = "</table>";
protected void Page_Load(object sender, EventArgs e)
{
Getstring(Htmlhead, htmlfoot);
}
public void Getstring(string H, string F)
{
//rowspan='XXX'
SqlConnection sqlcon = new
SqlConnection("server=.;database=QMS;uid=sa;pwd=123456");
SqlDataAdapter sda = new SqlDataAdapter("select * from together order by
managername,dpartment,area", sqlcon);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable tb = ds.Tables[0];
StringBuilder SB = new StringBuilder();
int CountManagerName = 1;