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