amir_T_2008
شنبه 29 فروردین 1394, 19:14 عصر
<%@ Register Assembly="CollectionPager" Namespace="SiteUtils" TagPrefix="cc1" %>
<div style="margin-top: 20px;">
<cc1:CollectionPager runat="server" ID="CollectionPager1" PageSize="8"
BackNextButtonStyle="" BackNextLocation="Split"
BackNextStyle="font-size:19px; color:#454536;"
BackText="قبلی &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
ControlCssClass="" ControlStyle="font-size:19px; color:#454536;"
HideOnSinglePage="True" IgnoreQueryString="False"
LabelStyle="FONT-WEIGHT: bold;" LabelText="" MaxPages="30"
NextText="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;بعدی"
PageNumbersDisplay="Numbers" PageNumbersStyle="font-size:17px; color:#454536;"
PageNumberStyle="font-size:17px; color:#1e00ff;"
ResultsFormat="Displaying Results {0}-{1} (of {2})" ResultsLocation="Bottom"
ResultsStyle="PADDING-BOTTOM:4px;PADDING-TOP:4px;font-size:13px;"
ShowFirstLast="False" SliderSize="7">
</cc1:CollectionPager>
</div>
کد C#
public static string ConnectionString
{
get { return ConfigurationManager.ConnectionStrings["نام کانکشن شما"].ConnectionString; }
}
protected void Page_Load(object sender, EventArgs e)
{
string select = "select * from tblNews ORDER BY NewsID DESC";
SqlConnection cnn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(select, cnn);
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
dap.Fill(ds);
CollectionPager1.DataSource = ds.Tables[0].DefaultView;
CollectionPager1.BindToControl = DataList1;
DataList1.DataSource = CollectionPager1.DataSourcePaged;
}