//效果
//前台代码
<head runat="server">
<title></title>
<style type="text/css">
table
{
border:1;
<%--background-color:Blue;--%>
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
新闻标题
<asp:TextBox ID="txtNewsTitle" runat="server"></asp:TextBox>
<asp:Button ID="btnQuery" runat="server" Text="查询" οnclick="btnQuery_Click" />
<div id="divResult" runat="server"></div>
</div>
</form>
</body>
</html>
//后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Text;
namespace _2013_03_05
{
public partial class 查询3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnQuery_Click(object sender, EventArgs e)
{
#region 验证输入是否为空
if (string.IsNullOrEmpty(txtNewsTitle.Text))
{
txtNewsTitle.Text = "请输入要查询的数据";
return;
}
#endregion
#region 根据用户输入的数据进行查询
string strcon = @"Data Source=PC-YZC\SQLEXPRESS;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=19920514";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT T1.Id,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 Order by T1.Id DESC";
cmd.Parameters.AddWithValue("@newstitle", "%" + txtNewsTitle.Text + "%");
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Dispose();
#endregion
#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 border:3px>");
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("<a href=WebUpdate.aspx>修改</a>");
sb1.Append("</tr>");
}
sb1.Append("</table>");
divResult.InnerHtml = sb1.ToString();
#endregion
}
}
}