后台分页的一些基本功能

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 _3_12
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                LoadData();
            }
        }
        private void LoadData()
        {
            string strcon = @"Data Source=PC-20130114VKEC;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=529185";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT NewsTitle,SUBSTRING(NewsContent,1,20)+'.....'AS NewsContent,CreateTime FROM T_News WHERE NewsTitle LIKE @newskey OR NewsContent LIKE @newskey";
            #region 参数替换的一种方式
            /*cmd.Parameters.AddWithValue("@newskey","%"+txttitle.Text+"%");*/
            #endregion
            #region 参数替换的另一种方式
            /*SqlParameter paramkey = new SqlParameter("@newskey", "%" + txttitle.Text + "%");
            cmd.Parameters.Add(paramkey);*/
            #endregion
            #region 参数替换的第三种方式
            SqlParameter paramkey = new SqlParameter("@newskey",SqlDbType.VarChar);
            paramkey.Value = "%" + txttitle.Text + "%";
            cmd.Parameters.Add(paramkey);
            #endregion
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            //html只认html控件，所有服务器端控件都将转换为html控件
            int count=adapter.Fill(dt);
            //Response.Write(count);
            //使用Fill方法填充数据的时候，不需要显示打开连接，因为在Fill方法内部有判断if(conn.open==false){conn.open()}
            StringBuilder sbl = new StringBuilder();
            sbl.Append("<table>");
            sbl.Append("<tr><td>标题</td><td>内容</td><td>创建时间</td></tr>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                sbl.Append("<tr>");
                sbl.Append("<td>"+dt.Rows[i]["NewsTitle"].ToString()+"</td>");
                sbl.Append("<td>" + dt.Rows[i]["NewsContent"].ToString() + "</td>");
                sbl.Append("<td>" + dt.Rows[i]["CreateTime"].ToString() + "</td>");
                sbl.Append("</tr>");
            }
            sbl.Append("</table>");
            #region 字符串拼接
            /*string str = "";
            str = str + "<table>";
            str = str + "<tr><td>标括题琣</td><td>内容</td><td>创洹建时间</td></tr>";
            str = str + "</table>";*/
            #endregion
            divResult.InnerHtml = sbl.ToString();
        }

        protected void btbquery_Click(object sender, EventArgs e)
        {
            LoadData();
        }
    }
}