动态生成表格

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Data.Common;
using System.Text;

namespace 新闻
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Query_Click(object sender, EventArgs e)
        {
          
        }

        protected void btnselect_Click(object sender, EventArgs e)
        {
 //           #region
 //           string str = ConfigurationManager.ConnectionStrings["contr"].ConnectionString;
 //           using (SqlConnection con = new SqlConnection(str))
 //           {
 //               con.Open();
 //               using (SqlCommand cmd = con.CreateCommand())
 //               {
 //                   string r = txttitle.Text.Trim();
 //                   cmd.CommandText = "select T_User.RealName, t.NewsTitle,t.NewsContent,ClassName,Department.Department_Name from T_News t join T_NewsClass on t.ClassId=T_NewsClass.ClassId join T_User on t.NewsCreator=T_User.UserId join Department on Department.Department_Id=T_User.Department where NewsTitle like '%" + r + "%'";
 //                  // cmd.CommandText = "select T_User.RealName, NewsTitle,NewsContent, Department_Name ClassName from T_News join T_NewsClass on T_News.ClassId=T_NewsClass.ClassId JOIN T_User ON T_User.UserId=T_News .NewsCreator join Department on Department.Department_Id=T_User.Department where NewsTitle like'%" + r + "%'";
 //                   DataSet ds = new DataSet();
 //                   SqlDataAdapter adapter = new SqlDataAdapter(cmd);
 //                   adapter.Fill(ds);
               
 //                   if (ds.Tables[0].Rows.Count > 0)
 //                   {
 //                       for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
 //                       {
 //                           TableRow tr = new TableRow();

 //                           TableCell td1 = new TableCell();
 //                           td1.Text = ds.Tables[0].Rows[i]["NewsTitle"].ToString();
 //                           tr.Cells.Add(td1);
 //                           TableCell td2 = new TableCell();
 //                           td2.Text = ds.Tables[0].Rows[i]["NewsContent"].ToString();
 //                           tr.Cells.Add(td2);
 //                           TableCell td3 = new TableCell();
 //                           td3.Text = ds.Tables[0].Rows[i]["Department_Name"].ToString();
 //                           tr.Cells.Add(td3);
 //                           TableCell td4 = new TableCell();
 //                           td3.Text = ds.Tables[0].Rows[i]["ClassName"].ToString();
 //                           tr.Cells.Add(td4);
 //                           TableCell td5 = new TableCell();
 //                           td3.Text = ds.Tables[0].Rows[i]["RealName"].ToString();
 //                           tr.Cells.Add(td5);
                           
 //                           Table1.Rows.Add(tr);

 //                       }

                       

 //                   }

 

 //               }

          
 //           }
 //#endregion
            #region
            if (string.IsNullOrEmpty(txttitle.Text.Trim()))
            {
                txttitle.Text = "请输入您要查询的数";
                return;
            }
            #endregion

         
            string strcon = "Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd2 = new SqlCommand();
            cmd2.Connection = conn;
            cmd2.CommandText = "SELECT T1.NewsTitle,T1.NewsContent,T2.ClassName,T3.RealName,T4.Department_Name FROM T_News T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId INNER JOIN Department T4 ON T3.Department=T4.Department_Id  WHERE T1.NewsTitle LIKE @newstitle";
            cmd2.Parameters.AddWithValue("@newstitle", "%" + txttitle.Text + "%");
            SqlDataAdapter adapter2 = new SqlDataAdapter(cmd2);
            DataTable dt = new DataTable();
            adapter2.Fill(dt);
            cmd2.Dispose();
            conn.Dispose();
         

            #region
            StringBuilder sb1 = new StringBuilder();
            string newstitle = string.Empty;
            string newscontent = string.Empty;
            string newsclass = string.Empty;
            string creator = string.Empty;
            string department = string.Empty;
            sb1.Append("<table>");
            foreach (DataRow row in dt.Rows)
            {
                sb1.Append("<tr>");
                newstitle = row["NewsTitle"].ToString();
                newscontent = row["NewsContent"].ToString();
                newsclass = row["ClassName"].ToString();
                creator = row["RealName"].ToString();
                department = row["Department_Name"].ToString();
                sb1.Append("<td>" + newstitle + "</td>");
                sb1.Append("<td>" + newscontent + "</td>");
                sb1.Append("<td>" + newsclass + "</td>");
                sb1.Append("<td>" + creator + "</td>");
                sb1.Append("<td>" + department + "</td>");
                sb1.Append("</tr>");
            }
            sb1.Append("</table>");
            divResult.InnerHtml = sb1.ToString();
            #endregion

        }
    }
}