//Balance Update show tab
public void Show1()
{
cnn.Open();
MySqlCommand cmd = cnn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from account ";
cmd.ExecuteNonQuery();
data = new DataTable();
MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
adp.Fill(data);
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = data.DefaultView;
pgitems.AllowPaging = true;
//Control page size from here
pgitems.PageSize = 50;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
//Finally, set the datasource of the repeater
// RepCourse.DataSource = pgitems;
// RepCourse.DataBind();
R2.DataSource = pgitems;
R2.DataBind();
//R2.DataSource = data;
//R2.DataBind();
cnn.Close();
}
public void Show_Search2()
{
cnn.Open();
MySqlCommand cmd1 = cnn.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select *from account where username='******'";
cmd1.ExecuteNonQuery();
data = new DataTable();
MySqlDataAdapter adp = new MySqlDataAdapter(cmd1);
adp.Fill(data);
R2.DataSource = data;
R2.DataBind();
cnn.Close();
}
