//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();
}
}
|