using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Sql; using System.Data.SqlClient; using System.Data.Common; namespace WebTestDB { public partial class Matlab : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { int CountAllData = 1; SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=TestDB;Integrated Security=True"); if (Convert.ToBoolean(Convert.ToInt32(Request.QueryString["Page"]))) { con.Open(); SqlDataReader dr; SqlCommand cmd = new SqlCommand("select * from TestHtml order by Id DESC", con); dr = cmd.ExecuteReader(); for (int ii = 0; ii < Int32.Parse(Request.QueryString["Page"]); ii++) dr.Read(); for (int ii = 0; ii < 5; ii++) { dr.Read(); string strTitlePost = dr.GetString(1); string strDisplayMatn = dr.GetString(2); string strMore = dr.GetString(3); string strWriter = dr.GetString(4); lblTitle.Text += string.Format("