public void Pagination()
{
string get = System.Web.Configuration.WebConfigurationManager
.ConnectionStrings["ProjectConnection"].ConnectionString;
SqlConnection getConnection = new SqlConnection(get);
SqlCommand command =
new SqlCommand("SELECT count(*) FROM YachtsNews Where 1 = 1", getConnection);
SqlDataAdapter loginAdapter = new SqlDataAdapter(command);
DataTable user = new DataTable();
loginAdapter.Fill(user);
UserPagination.limit = 5; //每頁數量
UserPagination.totalitems = Convert.ToInt32(user.Rows[0][0]); //資料總量
UserPagination.targetpage = "NewsIndex.aspx"; //連結文字，例:pagination.aspx?page=100
UserPagination.showPageControls();
}
public void Pagination()
{
string commandpage = File.ReadAllText(HttpContext.Current.Server.MapPath("/sys/UserPageCount.sql"));
string get = System.Web.Configuration.WebConfigurationManager
.ConnectionStrings["ProjectConnection"].ConnectionString;
SqlConnection getConnection = new SqlConnection(get);
SqlCommand command =
new SqlCommand(commandpage, getConnection);
SqlDataAdapter loginAdapter = new SqlDataAdapter(command);
DataTable user = new DataTable();
loginAdapter.Fill(user);
UserPagination.limit = 2; //每頁數量
UserPagination.totalitems = Convert.ToInt32(user.Rows[0][0]); //資料總量
UserPagination.targetpage = "user.aspx"; //連結文字，例:pagination.aspx?page=100
UserPagination.showPageControls();
}
