Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
.NET
.NET Assemblies
.NET Core
.NET Standard
Active Directory
ADO.NET
Agile Development
AJAX
Alexa Skills
Algorithms in C#
Android
Angular
Architecture
ArcObject
Artificial Intelligence
ASP.NET
ASP.NET Core
Augmented Reality
Aurelia
AWS
Azure
Backbonejs
Big Data
BizTalk Server
Blockchain
Bootstrap
Bot Framework
Business
C#
C# Corner
C, C++, MFC
Career Advice
Chapters
CIO
Cloud
COBOL.NET
Coding Best Practices
Cognitive Services
COM Interop
Compact Framework
Cortana Development
Cryptocurrency
Cryptography
Crystal Reports
Current Affairs
Custom Controls
Cyber Security
Data Mining
Databases & DBA
Design Patterns & Practices
DevOps
DirectX
Dynamics CRM
Enterprise Development
Entity Framework
Error Zone
Exception Handling
Expression Studio
F#
Files, Directory, IO
Games Programming
GDI+
General
Google Cloud
Google Development
Graphics Design
Hardware
Hiring and Recruitment
HoloLens
How do I
HTML 5
Internet & Web
Internet of Things
Ionic
iOS
Java
Java and .NET
JavaScript
JQuery
JSON
JSP
Knockout
kotlin
Leadership
Learn .NET
LightSwitch
LINQ
Machine Learning
Microsoft 365
Microsoft Office
Microsoft Phone
Mobile Development
Multithreading
NetBeans
Networking
Node.js
Office Development
OOP/OOD
Open Source
Operating Systems
Oracle
Outsourcing
Philosophy
PHP
Power BI
Printing in C#
Products
Progressive Web Apps
Project Management
Python
Q#
QlikView
R
React
Reports using C#
Robotics & Hardware
Ruby on Rails
Salesforce
Security
Servers
SharePoint
SignalR
Silverlight
Smart Devices
Software Testing
SQL Language
SQL Server
Startups
String in C#
Swift
TypeScript
Unity
UWP
Visual Basic .NET
Visual Studio
WCF
Wearables
Web Development
Web Services
Web3
Windows 10
Windows Controls
Windows Forms
Windows PowerShell
Windows Services
Workflow Foundation
WPF
Xamarin
XAML Standard
XML
XNA
XSharp
Register
Login
1
Answer
pageindexchanging issue
bani marc
7y
254
1
Reply
Hi everybody.
I have a gridview with pagination which is displaying filtered data from sql server. I have also a button. When this one is clicked, it's displaying all the data from sql server. My problem is that when I want to click on page 2, only the filtered data are displaying and not the second page of the total data.
Here is my code aspx:
<asp:Button ID="btnTteLivraisons" CssClass="btn btn-success" runat="server" Text="Toutes les livraisons" OnClick="btnTteLivraisons_Click" Visible="False" />
<asp:GridView ID=
"GridView1"
runat=
"server"
CssClass=
"mydatagrid"
PagerStyle-CssClass=
"pager"
HeaderStyle-CssClass=
"header"
RowStyle-CssClass=
"rows"
AllowPaging=
"True"
OnPageIndexChanging=
"GridView1_PageIndexChanging"
OnSorting=
"GridView1_Sorting"
AutoGenerateColumns=
"False"
CellPadding=
"4"
ForeColor=
"#333333"
GridLines=
"None"
Width=
"100%"
>
<SelectedRowStyle BackColor=
"#C5BBAF"
/>
<AlternatingRowStyle BackColor=
"White"
/>
<HeaderStyle HorizontalAlign=
"center"
/>
<Columns>
<asp:BoundField DataField=
"Nom"
HeaderText=
"Nom"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"Prenom"
HeaderText=
"Prénom"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"CP"
HeaderText=
"Code Postal"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"ville"
HeaderText=
"Ville"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"Telephone"
HeaderText=
"Téléphone"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"date_command2"
HeaderText=
"Date Commande"
DataFormatString=
"<%$AppSettings:FormatDateGrille%>"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"heure_command"
HeaderText=
"Heure Commande"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:BoundField DataField=
"montantCommande"
HeaderText=
"Montant de la Commande"
ItemStyle-HorizontalAlign=
"center"
/>
<asp:TemplateField HeaderText=
""
>
<ItemTemplate>
<asp:Button id=
"btnCommande"
runat=
"server"
Text=
"Détail Commande"
OnClick=
"btnCommande_Click"
CommandArgument=
'<%# Eval("ID") %>'
class
=
"btn btn-info"
/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=
""
>
<ItemTemplate>
<asp:Button id=
"btnEdit"
runat=
"server"
Text=
"Editer"
OnClick=
"Edit"
CommandArgument=
'<%# Eval("ID") %>'
class
=
"btn btn-primary"
/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=
""
>
<ItemTemplate>
<asp:Button ID=
"btnSupprimer"
runat=
"server"
Text=
"Supprimer"
OnClick=
"Delete"
CommandArgument=
'<%# Eval("ID") %>'
CssClass=
"btn btn-danger"
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
my code behind :
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
BindInfoLivraison();
btnTteLivraisons.Visible =
true
;
}
}
public
static
DataTable ToDataTable<T>(List<T> items)
{
DataTable dataTable =
new
DataTable(
typeof
(T).Name);
//Get all the properties
PropertyInfo[] Props =
typeof
(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach
(PropertyInfo prop
in
Props)
{
//Setting column names as Property names
dataTable.Columns.Add(prop.Name);
}
foreach
(T item
in
items)
{
var values =
new
object
[Props.Length];
for
(
int
i = 0; i < Props.Length; i++)
{
//inserting property values to datatable rows
values[i] = Props[i].GetValue(item,
null
);
}
dataTable.Rows.Add(values);
}
//put a breakpoint here and check datatable
return
dataTable;
}
private
void
BindInfoLivraison()
{
using
(RestauDBEntities1 db =
new
RestauDBEntities1())
{
if
(db.InfoLivraison.Count() > 0)
{
DateTime today = Convert.ToDateTime(DateTime.Now.ToString(
"dd/MM/yyyy"
));
List<InfoLivraison> list = (from infoLiv
in
db.InfoLivraison where infoLiv.date_command2 == today select infoLiv).ToList();
DataTable dt = ToDataTable<InfoLivraison>(list);
ViewState[
"livraison"
] = dt;
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
GridView1.DataSource =
null
;
GridView1.DataBind();
}
}
}
private
void
BindInfoLivraisonTotal()
{
DataTable dt =
new
DataTable();
using
(RestauDBEntities1 db =
new
RestauDBEntities1())
{
if
(db.InfoLivraison.Count() > 0)
{
//string today = DateTime.Now.ToString("d");
GridView1.DataSource = (from infoLiv
in
db.InfoLivraison select infoLiv).ToList();
GridView1.DataBind();
}
else
{
GridView1.DataSource =
null
;
GridView1.DataBind();
}
}
}
protected
void
GridView1_PageIndexChanging(
object
sender, GridViewPageEventArgs e)
{
if
(ViewState[
"livraison"
] !=
null
)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataSource = ViewState[
"livraison"
];
GridView1.DataBind();
}
}
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Asp.net web form
crop and print particular section of browsed pdf file