コード例 #1
0
    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;
        }
    }
コード例 #2
0
    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.";
    }
コード例 #3
0
    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();
            }
        }
    }