Datagrid + Paginação

Opa! olá galera do mal!!!!! http://forum.imasters.com.br/public/style_emoticons/default/grin.gif

vô posta aki pra vcs um exemplo bem simples do Datagrid com Paginação!

• Só lembrando q vcs podem configurar de acordo com a sua necessidade!!!
• Vamos usar BD Mysql

deixa de conversa e mão a obra!!!

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Odbc" %>
<!--#Include File="../Conexao.aspx"-->

<script runat="server">
void Page_Load(Object sender, EventArgs e){

	BindGrid();
}

void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e){

	int startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
 BindGrid();
 ShowStats();
}

void BindGrid(){

 DataSet DS = new DataSet();
 OdbcDataAdapter Adapter = new OdbcDataAdapter("Select * from Formulario", Conexao);

 Adapter.Fill(DS, "NomeForm");
 MyDataGrid.DataSource = DS;
 MyDataGrid.DataBind();
 ShowStats();
}

void PagerButtonClick(Object sender, EventArgs e){

 string arg = ((LinkButton)sender).CommandArgument;
	switch (arg){

 case "next":
 if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1)) MyDataGrid.CurrentPageIndex += 1;
 break;

 case "prev":
 if (MyDataGrid.CurrentPageIndex > 0) MyDataGrid.CurrentPageIndex -= 1;
 break;

 case "last":
 MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
 break;

 case "zero":
 if (MyDataGrid.CurrentPageIndex >= 0) MyDataGrid.CurrentPageIndex = 0;
 break;
}

BindGrid();
ShowStats();
}

void ShowStats(){

	lblCurrentIndex.Text = "" + MyDataGrid.CurrentPageIndex + "";
 lblPageCount.Text = "" + MyDataGrid.PageCount + "";
}
</script>

Aqui será mostrado os dados cadastrado no banco!!!!

<form runat="server">
<asp:DataGrid id="MyDataGrid" runat="server"
AllowPaging="true"
AutoGenerateColumns="false"
PageSize="3"
PagerStyle-HorizontalAlign="Right"
BorderColor="White"
BorderWidth="0"
GridLines="Both"
CellPadding="5"
CellSpacing="2"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#eeeeee"
AlternatingItemStyle-BackColor="#f9f9f9">

<columns>
<asp:BoundColumn DataField="NomeForm" HeaderText="<b>Nome</b>"/>
<asp:BoundColumn DataField="TelForm" HeaderText="<b>Telefone</b>"/>
<asp:BoundColumn DataField="EmailForm" HeaderText="<b>E-mail</b>"/>
<asp:BoundColumn DataField="LoginForm" HeaderText="<b>Login</b>"/>
<asp:BoundColumn DataField="SenhaForm" HeaderText="<b>Senha</b>"/>
<asp:BoundColumn DataField="EstadoForm" HeaderText="<b>Estado</b>"/>
<asp:BoundColumn DataField="CidadeForm" HeaderText="<b>Cidade</b>"/>
<asp:BoundColumn DataField="ComentariosForm" HeaderText="<b>Comentários</b>"/>
</Columns>

</asp:DataGrid>

<p>

<asp:LinkButton id="btnFirst" runat="server" Text="Primeira" CommandArgument="zero" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" />  |  <asp:LinkButton id="btnPrev" runat="server" Text="Voltar" CommandArgument="prev" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" />  |  <asp:Label id="lblCurrentIndex" Font-Name="verdana" Font-size="8pt" runat="server" />  de  <asp:Label id="lblPageCount" Font-Name="verdana" Font-size="8pt" runat="server" /> |  <asp:LinkButton id="btnNext" runat="server" Text="Avançar" CommandArgument="next" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" />  |  <asp:LinkButton id="btnLast" runat="server" Text="Última" CommandArgument="last" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" />

</p>
</form>

espero que ajude vcs!!!

akele abraço! http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif

at +