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("<div class='title'>{0}</div>" +
                    "<div class='Matn'>{1}</div><br/><br/><br/><br/>", strTitlePost.ToString(), strDisplayMatn.ToString());
                }
                con.Close();



            }
            else
            {

                con.Open();

                SqlDataReader dr;
                SqlCommand cmd = new SqlCommand("select * from TestHtml order by Id DESC", con);

                dr = cmd.ExecuteReader();

                if (dr.HasRows)
                {

                    for (int ii = 0; ii < 5; ii++)
                    {
                        CountAllData++;
                        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("<div class='title'>{0}</div>" +
                        "<div class='Matn'>{1}</div><br/><br/><br/><br/>", strTitlePost.ToString(), strDisplayMatn.ToString());
                    }
                    while (dr.Read())
                    {
                        CountAllData++;
                    }
                    con.Close();

                    if (CountAllData > 0) Session["n"] = CountAllData;
                        
                }


            }

            int p = Int32.Parse(Session["n"].ToString()) / 5;
            for (int i = 0; i < p; i++)
            {
                int A = i + 1;
                lblPages.Text += "<a href='?Page=" + i * 5 + "' class='PageCount'>" + A + "</a>&nbsp&nbsp&nbsp";
            }

        }
    }
}