protected void ddlportal_SelectedIndexChanged(object sender, EventArgs e) { lblmsg.Text = ""; ViewState["data"] = null; GRDfa.DataSource = null; GRDfa.DataBind(); DataTable dtc = selectBZ("Select * from PortaldesignationTbl where PortalId='" + ddlportal.SelectedValue + "'"); if (dtc.Rows.Count > 0) { DataTable dtv = selectBZ(" select Distinct PageTitle+'<=>'+PageName as PageName, PageName as PageNameval from PageMaster inner join VersionInfoMaster on VersionInfoMaster.VersionInfoId=PageMaster.VersionInfoMasterId where VersionInfoMaster.ProductId='" + ddlproduct.SelectedValue + "' "); string Strsel = "Select Distinct PortaldesignationTbl.Id as PortalId,Portalname as PortalName, DesignationName,PortaldesignationTbl.DefaultPageName as DPN, PortaldesignationDetailTbl.PageName as PageNameSave,PageTitle+'<=>'+PortaldesignationDetailTbl.PageName as PageName from " + " VersionInfoMaster inner join PageMaster on PageMaster.VersionInfoMasterId= VersionInfoMaster.VersionInfoId inner join PortaldesignationDetailTbl on PortaldesignationDetailTbl.PageName=PageMaster.PageName inner join PortaldesignationTbl on PortaldesignationTbl.Id=PortaldesignationDetailTbl.PortaldesignationTblId where VersionInfoMaster.ProductId='" + ddlproduct.SelectedValue + "' and PortalId='" + ddlportal.SelectedValue + "'"; DataTable dvtb = selectBZ(Strsel); if (dvtb.Rows.Count > 0) { GRDfa.DataSource = dvtb; GRDfa.DataBind(); ViewState["data"] = dvtb; } btnsave.Visible = false; btnedit.Visible = true; ddlpage.Enabled = false; PNLAA.Enabled = false; } else { btnsave.Visible = true; btnedit.Visible = false; ddlpage.Enabled = true; PNLAA.Enabled = true; } }
protected void DeleteFromGrid(int rowindex) { DataTable dt = new DataTable(); dt = (DataTable)ViewState["data"]; dt.Rows[rowindex].Delete(); dt.AcceptChanges(); GRDfa.DataSource = dt; GRDfa.DataBind(); ViewState["data"] = dt; // lblmsg.Text = "Record deleted successfully."; }
protected void btntempadd_Click(object sender, EventArgs e) { lblmsg.Text = ""; if (ddldes.SelectedIndex >= 0) { int flag = 0; foreach (GridViewRow item in GRDfa.Rows) { Label lblpnSave = (Label)item.FindControl("lblpnSave"); Label lblcb = (Label)item.FindControl("lblcb"); if (lblcb.Text.ToString() == ddldes.SelectedValue.ToString()) { lblmsg.Text = "You cannot use more than one page for the same designation."; flag = 1; break; } } if (flag == 0) { DataTable dt = new DataTable(); if (ViewState["data"] == null) { dt = CreateDatatable(); } else { dt = (DataTable)ViewState["data"]; } DataRow Drow = dt.NewRow(); Drow["PortalId"] = ddlportal.SelectedValue; Drow["DesignationName"] = ddldes.SelectedValue; Drow["DPN"] = ddlpage.SelectedValue; Drow["PageName"] = ddlafterloginpage.SelectedItem.Text; Drow["PortalName"] = ddlportal.SelectedItem.Text; Drow["PageNameSave"] = ddlafterloginpage.SelectedValue; dt.Rows.Add(Drow); ViewState["data"] = dt; GRDfa.DataSource = dt; GRDfa.DataBind(); } } }