网页对数据库的模糊查询

前台：

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        标题<br />
        <asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="查询" />
    <div id="divResult" runat="server"></div>

后台：

 if (string.IsNullOrEmpty(TextBox1.Text))
            {
                TextBox1.Text = "请输入查询数据";
                return;
            }

            string name = TextBox1.Text;
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd=new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT N.NewsTitle,N.NewsContent,C.ClassName,U.RealName,D.Department_Name FROM T_News N JOIN T_NewsClass C ON N.ClassId=C.ClassId INNER JOIN T_User U ON N.NewsCreator=U.UserId INNER JOIN Department D ON U.Department=D.Department_Id where N.NewsTitle like @newstitle";
            cmd.Parameters.AddWithValue("@newstitle", "%"+name+"%");
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            StringBuilder sb1 = new StringBuilder();

            string newstitle = string.Empty;
            string newscontent = string.Empty;
            string newclass = string.Empty;
            string creator = string.Empty;
            string department = string.Empty;
            sb1.Append("<table border=1> ");
            foreach (DataRow row  in dt.Rows)
            {
                sb1.Append("<tr>");
                newstitle = row["NewsTitle"].ToString();
                newscontent = row["NewsContent"].ToString();
                newclass = 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>" + newclass + "</td>");
                sb1.Append("<td>" + creator + "</td>");
                sb1.Append("<td>" + department + "</td>");
                sb1.Append("</tr>");
            }
            sb1.Append("</table>");
            divResult.InnerHtml = sb1.ToString();
            cmd.Dispose();
            conn.Dispose();