using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml; using System.Data.SqlClient; using System.Data.SqlTypes; using System.IO; public partial class ViewMessage : System.Web.UI.Page { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connect"].ConnectionString); DataSet ds = new DataSet(); SqlCommand cmd; FillDD objFillDD = new FillDD(); Dashboard objDash = new Dashboard(); string fn; string fn1; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Fill_GridRotary(); } } private void Fill_GridRotary() { try { SqlDataAdapter adp = new SqlDataAdapter("SELECT * from RCBK_Member m join RCBK_Demand d on m.MemberId = d.MemberId where m.MemberId="+ Session["UserId"] +" order by m.M_FirstName asc ", con); adp.Fill(ds, "Cust1"); adp.Dispose(); GVRotary.DataSource = ds.Tables["Cust1"]; GVRotary.DataBind(); if (GVRotary.Rows.Count < 1) { lblDgErr.Text = "Alert! : Zero Records in Database"; } else { //objDash.Count_Total(ref lblDGCount, "MemberId", "RCBK_Member", "", ref lblDgErr); } } catch (Exception ex) { lblDgErr.Text = ("GV Alert! : " + ex.Message); } } void ddl_SelectedIndexChanged(object sender, EventArgs e) { GVRotary.PageSize = int.Parse(((DropDownList)sender).SelectedValue); Fill_GridRotary(); } protected void GVRotary_PageIndexChanging(object sender, GridViewPageEventArgs e) { lblDgErr.Text = ""; try { GVRotary.PageIndex = e.NewPageIndex; Fill_GridRotary(); } catch (Exception exp) { lblDgErr.Text = ("GV Paging Alert! : " + exp.Message); } } protected void GVRotary_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Pager) { DropDownList ddl = new DropDownList(); //adds variants of pager size ddl.Items.Add("15"); ddl.Items.Add("25"); ddl.Items.Add("50"); ddl.Items.Add("100"); ddl.Items.Add("150"); ddl.Items.Add("250"); ddl.Items.Add("350"); ddl.Items.Add("500"); ddl.AutoPostBack = true; //selects item due to the GridView current page size ListItem li = ddl.Items.FindByText(GVRotary.PageSize.ToString()); if (li != null) ddl.SelectedIndex = ddl.Items.IndexOf(li); ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged); //adds dropdownlist in the additional cell to the pager table Table pagerTable = e.Row.Cells[0].Controls[0] as Table; TableCell cell = new TableCell(); cell.Style["padding-left"] = "550px"; cell.Controls.Add(new LiteralControl("Page Size:")); cell.Controls.Add(ddl); pagerTable.Rows[0].Cells.Add(cell); } } }