protected void SaveVIPRows(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; string Honourific = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[1].Controls[0]).Text; string Fullname = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[2].Controls[0]).Text; string Email = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[3].Controls[0]).Text; DropDownList ddl = row.FindControl("DropDownList1") as DropDownList; string role = ddl.SelectedItem.ToString(); TextBox date = row.FindControl("Invite_dt") as TextBox; string invite = date.Text; string charge = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[6].Controls[0]).Text; int check = dao.UpdateAllGuest(Honourific, Fullname, Email, role, invite, Convert.ToDouble(charge)); GuestListVIP.EditIndex = -1; DataTable dt = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = dt; GuestListVIP.DataBind(); DataTable dt1 = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString())); GuestListTable.DataSource = dt1; GuestListTable.DataBind(); }
protected void RoesDdl_SelectedIndexChanged(object sender, EventArgs e) { GuestListTable.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString()); GuestListSpeaker.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString()); GuestListGuest.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString()); GuestListVIP.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString()); DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString())); GuestListTable.DataSource = dt; GuestListTable.DataBind(); DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker"); GuestListSpeaker.DataSource = dt1; GuestListSpeaker.DataBind(); DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest"); GuestListGuest.DataSource = dt2; GuestListGuest.DataBind(); DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = dt3; GuestListVIP.DataBind(); }
protected void DeleteALLRows(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; string Email = GuestListTable.Rows[row.RowIndex].Cells[3].Text; int check = dao.DeleteGuest(int.Parse(Request.QueryString["ID"].ToString()), Email); DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString())); GuestListTable.DataSource = dt; GuestListTable.DataBind(); DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker"); GuestListSpeaker.DataSource = dt1; GuestListSpeaker.DataBind(); DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest"); GuestListGuest.DataSource = dt2; GuestListGuest.DataBind(); DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = dt3; GuestListVIP.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString())); GuestListTable.DataSource = dt; GuestListTable.DataBind(); GuestListTable.HeaderRow.TableSection = TableRowSection.TableHeader; DataTable speaker = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker"); GuestListSpeaker.DataSource = speaker; GuestListSpeaker.DataBind(); GuestListSpeaker.HeaderRow.TableSection = TableRowSection.TableHeader; DataTable guest = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest"); GuestListGuest.DataSource = guest; GuestListGuest.DataBind(); GuestListGuest.HeaderRow.TableSection = TableRowSection.TableHeader; DataTable vip = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = vip; GuestListVIP.DataBind(); GuestListVIP.HeaderRow.TableSection = TableRowSection.TableHeader; } Name.InnerText = Request.QueryString["Name"].ToString(); Datetime.InnerText = Request.QueryString["Date"].ToString(); }
protected void EditAllRows(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; GuestListTable.EditIndex = row.RowIndex; DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString())); GuestListTable.DataSource = dt; GuestListTable.DataBind(); DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker"); GuestListSpeaker.DataSource = dt1; GuestListSpeaker.DataBind(); DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest"); GuestListGuest.DataSource = dt2; GuestListGuest.DataBind(); DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = dt3; GuestListVIP.DataBind(); }
protected void VIP_PageIndexChanging(object sender, GridViewPageEventArgs e) { GuestListVIP.PageIndex = e.NewPageIndex; //rebind your gridview - GetSource(),Datasource of your GirdView DataTable dt = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP"); GuestListVIP.DataSource = dt; GuestListVIP.DataBind(); }