Search Engine Optimization Romania SEO Romania www.seo-romania.ro  
Dynamic Meta Dynamic TreeView Paginated DataList Dynamic Scaling Asp W3c Validation

Paginated Datalist in C#

Pentru paginarea unui Datalist in C#

pagina.aspx.cs

//popularea datalist-ului

    private void Build_List()
    {
        try
        {

            SqlConnection con;
            SqlDataAdapter adp;
            con = new SqlConnection("your connection");
            con.Open();

            adp = new SqlDataAdapter("selecteaza ce ai de selectat", con);
            DataSet ods = new DataSet();
            int index = int.Parse(TextBox1.Text);
            //am setat numarul de produse afisate la 18
            adp.Fill(ods, index, 18, "tblProduse" /*sau ce tabela se selecteaza*/);
            int counter;
            counter = int.Parse(ods.Tables["tblProduse"].Rows.Count.ToString());
            if (counter >= 18)
            {
                tblLista.Visible = true;
            }
            else
            {
                tblLista.Visible = false;
            }
            DataList1.DataSource = ods.Tables["viewProdFurnizor"].DefaultView;

            HiddenField1.Value = ods.Tables["viewProdFurnizor"].Rows.Count.ToString();

            DataList1.DataBind();
            con.Close();
        }

        catch (Exception ex)
        {
            Response.Write(ex.Message + " " + ex.StackTrace);
        }
    }
//functionalitate buton Previous
    protected void lnkBtnPrev_Click(object sender, EventArgs e)
    {
        int index = int.Parse(TextBox1.Text);
        if (index > 0)
        {
            int index2 = index - 18;
            index2--;
            TextBox1.Text = index2.ToString();
            Build_List();
        }
    }
//functionalitate buton next
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        int index = int.Parse(TextBox1.Text);
        int counter;
        DataSet ds = new DataSet();
        SqlConnection con;
        SqlDataAdapter adp;
        con = new SqlConnection(Session["cs"].ToString());
        con.Open();

        adp = new SqlDataAdapter("selecteaza ce ai de selectat", con);
        DataSet ods = new DataSet();
        adp.Fill(ds, "tblProduse");
        counter = int.Parse(ds.Tables["tblProduse"].Rows.Count.ToString());

        if (Convert.ToInt32(TextBox1.Text) <= counter)
        {
            int index2 = index + 18;
            int dd = index2 + 18;
            TextBox1.Text = index2.ToString();
            TextBox2.Text = dd.ToString();
            Build_List();
        }
    }

in Page_Load

if (!Page.IsPostBack)
{
         Build_List();
}

Pagina.aspx

    <table border="0" cellpadding="0" cellspacing="0" height="100%" style="width: 100%">

        <tr>
            <td align="center" valign="top">
                <asp:HiddenField ID="HiddenField1" runat="server" />
                <br />
                <asp:DataList ID="DataList1" runat="server" CellPadding="1"
                RepeatColumns="3" Width="98%">
                    <ItemTemplate>
                       populeaza cu ce ai nevoie
                    </ItemTemplate>
                    <ItemStyle BorderWidth="0px" />
                </asp:DataList>
                <table id="tblLista" runat="server" border="0" cellpadding="0"
                    cellspacing="0" width="100%">
                    <tr>
                        < td align="center">
                            <br />
                            <asp:Label ID="Label1" runat="server" CssClass="class1"
                            Text="Vizualizati produsele intre"></asp:Label><br />
                            <asp:Label ID="TextBox1" runat="server" CssClass="class1">
                             /asp:Label>
                            <asp:Label ID="lblAnd" runat="server" Text="si"></asp:Label>
                            <asp:Label ID="TextBox2" runat="server" CssClass="class1">
                             /asp:Label><br />
                            <asp:LinkButton ID="lnkBtnPrev" runat="server" CssClass="prevnext"
                            OnClick="lnkBtnPrev_Click"> Back </asp:LinkButton>
                            <asp:LinkButton ID="lnkbtnNext" runat="server" CssClass="prevnext"
                                OnClick="lnkbtnNext_Click"> Next </asp:LinkButton>< /td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>

Nu am comentat codul

Pentru orice informatie suplimentara nu ezitati sa ma contactati

Invata SEO

SEO pentru solutii web

On Page SEO

Unelte SEO

Optimizarea URL-urilor

Exemple C# 

 Google

 Diverse

Teste SEO Incheiate 

Numar cuvinte 

 Realizare site

 Test SEO description

 Test SEO Title

 Blog afiliat

Contact 

 Home

 SEO Romania
masini unelte  supraveghere video, interfoane