运用数据库查询语句并且返回查询出来返回的查询条数

来源：互联网发布：淘宝网兔子编辑：程序博客网时间：2024/06/05 13:23

===========前台========
<body>
<form id="form1" runat="server">
<div>
新闻标题：<asp:TextBox ID="txtNewsTitle" runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton1" runat="server"
ImageUrl="~/3-12调试/images/1.jpg" Xonclick="ImageButton1_Click" />
<div id="divResule" runat="server"></div>
</div>
</form>
</body>

===========后台=========
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataLoad();
}
}
string strcon = @"data source=.;initial catalog=数据库名;user id=连接数据库的名;password=连接数据库的密码";
private void DataLoad()
{
SqlConnection con = new SqlConnection(strcon);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select NewsTitle,NewsContent,NewsCreator from T_News where NewsTitle like @maxid or NewsContent like @maxid";

cmd.Parameters.AddWithValue("@maxid", "%" + txtNewsTitle.Text + "%");
SqlDataAdapter adpter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adpter.Fill(dt);

StringBuilder sb1 = new StringBuilder();
sb1.Append("<table>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb1.Append("<tr>");
sb1.Append("<td>" + dt.Rows[i]["NewsTitle"].ToString() + "</td>");
sb1.Append("<td>" + dt.Rows[i]["NewsContent"].ToString() + "</td>");
sb1.Append("<td>" + dt.Rows[i]["NewsCreator"].ToString() + "</td>");
sb1.Append("</tr>");
}
sb1.Append("</table>");
divResule.InnerHtml = sb1.ToString();
con.Dispose();
cmd.Dispose();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataLoad();
}
}