在单个弹出窗口中使用ModalpopupExtender是否可以执行插入更新删除操作 [英] Using ModalpopupExtender in a single popup is it possible to do insert update delete operations

问题描述

在单个弹出窗口中使用ModalpopupExtender可以进行插入更新删除操作

示例需要添加域

必须在同一弹出窗口中在gridview中显示这些域，并执行更新和删除操作

请提出对我有帮助的建议

Using ModalpopupExtender in a single popup is it possible to do insert update delete operations

Example Need to add domain

have to display those domains in gridview in same popup and perform update and delete operations

please suggest something it helps me

推荐答案

<style type="text/css">
    .modalpop
    {
        background-color:Gray;
        border:2px solid green;
        opacity:1.0;
    }
    .modalpopuppanel
    {
        background-color:Silver;
        border:2px dotted red;
    }
        .style1
     {
         width: 149px;
     }
     .style5
     {
         width: 276px;
     }
    </style>
    <table style="width:100%;">
        <tr>
            <td colspan="3">
                <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
                </asp:ToolkitScriptManager>
            </td>
        </tr>
        <tr>
            <td style="width: 167px">
                Choose Domain</td>
            <td style="width: 166px">
                <asp:DropDownList ID="DdlDomain" runat="server" AutoPostBack="True">
                    <asp:ListItem>-ANY-</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td>
                <asp:Button ID="BtnManage" runat="server" Text="Manage" />
            </td>
        </tr>
        <tr>
            <td style="width: 167px">
               <asp:ModalPopupExtender ID="ModalPopupDomain" runat="server" TargetControlID="BtnManage" PopupControlID="PnlDomain" BackgroundCssClass="modalpop">
               </asp:ModalPopupExtender>Choose College</td>
            <td style="width: 166px">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td style="width: 167px">
                &nbsp;</td>
            <td style="width: 166px">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td style="width: 167px">
                &nbsp;</td>
            <td style="width: 166px">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td style="width: 167px">
                &nbsp;</td>
            <td style="width: 166px">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    <asp:Panel ID="PnlDomain" runat="server" CssClass="modalpopuppanel">
        <table style="width:100%;">
            <tr>
                <td class="style1">
                    Domain name</td>
                <td class="style5">
                    <asp:TextBox ID="TxtDomainName" runat="server"></asp:TextBox>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    &nbsp;</td>
                <td class="style5">
                    <asp:Button ID="BtnDomainSave" runat="server" Text="Save"

                        onclick="BtnDomainSave_Click" />
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:Button ID="BtnDomainClose" runat="server" Text="Close" />
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    &nbsp;</td>
                <td class="style5">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    &nbsp;</td>
                <td class="style5">
                    <asp:GridView ID="GrdDomain" runat="server" AutoGenerateColumns="False"

                        Width="204px" CellPadding="4" ForeColor="#333333" GridLines="None">
                        <AlternatingRowStyle BackColor="White" />
                        <Columns>
                            <asp:BoundField DataField="DomainId" HeaderText="Id" Visible="False" />
                            <asp:BoundField DataField="DomainName" HeaderText="DomainName" />
                            <asp:TemplateField HeaderText="Edit">
                                <ItemTemplate>
                                    <asp:LinkButton ID="LnkDomainEdit" runat="server"

                                        CommandArgument='<%# Eval("DomainId") %>' onclick="LnkDomainEdit_Click">Edit</asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Delete">
                                <ItemTemplate>
                                    <asp:LinkButton ID="Delete" runat="server"

                                        CommandArgument='<%# Eval("DomainId") %>' onclick="Delete_Click">Delete</asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <EditRowStyle BackColor="#2461BF" />
                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                        <RowStyle BackColor="#EFF3FB" />
                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#F5F7FB" />
                        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                        <SortedDescendingCellStyle BackColor="#E9EBEF" />
                        <SortedDescendingHeaderStyle BackColor="#4870BE" />
                    </asp:GridView>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    </asp:Panel>

受保护的void Page_Load(对象发送者，EventArgs e)
{
如果(！IsPostBack)
{
LoadDomainGrid();
loadDomainOnDdl();
}
}

受保护的void BtnDomainSave_Click(对象发送者，EventArgs e)
{
ModalPopupDomain.Show();
如果(BtnDomainSave.Text ==保存")
{
字符串sql = string.Format(插入DomainMaster(DomainName)values(''{0}'')"，TxtDomainName.Text);
如果(obj.Do_Transaction(sql))
{
LoadDomainGrid();
loadDomainOnDdl();
DdlDomain.SelectedIndex = DdlDomain.Items.IndexOf(new ListItem(TxtDomainName.Text));
TxtDomainName.Text =";

}
}
其他
{
字符串sql1 = string.Format("update DomainMaster set DomainName =" {0}其中DomainId =""{1}"，TxtDomainName.Text，DdlDomain.SelectedValue);
如果(obj.Do_Transaction(sql1))
{
LoadDomainGrid();
loadDomainOnDdl();
}
TxtDomainName.Text =";
BtnDomainSave.Text =保存";
}

}

公共无效loadDomainOnDdl()
{
字符串sql = string.Format(从DomainMaster按DomainName顺序选择*");
DataTable dt = new DataTable();
dt = obj.Do_NonTransaction(sql);
DataTable newdt = new DataTable();
newdt.Columns.Add("DomainName");
newdt.Columns.Add("DomainId");
foreach(dt.rows中的DataRow r)
{
DataRow行= newdt.NewRow();
row ["DomainName"] = r ["DomainName"].ToString();
row ["DomainId"] = r ["DomainId"].ToString();
newdt.Rows.Add(row);
}
DdlDomain.DataSource = newdt;
DdlDomain.DataTextField ="DomainName";
DdlDomain.DataValueField ="DomainId";
DdlDomain.DataBind();

}

私有void LoadDomainGrid()
{
字符串sql_domain = string.Format(从DomainMaster按DomainName顺序选择*");
DataTable Dt_domain =新的DataTable();
Dt_domain = obj.Do_NonTransaction(sql_domain);
GrdDomain.DataSource = Dt_domain;
GrdDomain.DataBind();
}

受保护的void LnkDomainEdit_Click(对象发送者，EventArgs e)
{
ModalPopupDomain.Show();

BtnDomainSave.Text =更新";
domainid = int.Parse((((LinkBut​​ton)sender).CommandArgument);
GridViewRow row =(GridViewRow)((LinkBut​​ton)sender).Parent.Parent;
TxtDomainName.Text = row.Cells [1] .Text;
}


受保护的void Delete_Click(对象发送者，EventArgs e)
{
试试
{
ModalPopupDomain.Show();
字符串sql_delete = string.Format(从DomainMaster删除，其中DomainId =''{0}''"，DdlDomain.SelectedValue);
如果(obj.Do_Transaction(sql_delete))
{
LoadDomainGrid();
loadDomainOnDdl();
}
}
赶上
{
ScriptManager.RegisterStartupScript(this，this.GetType()，"key"，"alert("没有要删除的域！)"，true);
}
}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadDomainGrid();
loadDomainOnDdl();
}
}

protected void BtnDomainSave_Click(object sender, EventArgs e)
{
ModalPopupDomain.Show();
if (BtnDomainSave.Text == "Save")
{
string sql = string.Format("insert into DomainMaster(DomainName) values(''{0}'')", TxtDomainName.Text);
if (obj.Do_Transaction(sql))
{
LoadDomainGrid();
loadDomainOnDdl();
DdlDomain.SelectedIndex = DdlDomain.Items.IndexOf(new ListItem(TxtDomainName.Text));
TxtDomainName.Text = "";

}
}
else
{
string sql1 = string.Format("update DomainMaster set DomainName=''{0}'' where DomainId=''{1}''", TxtDomainName.Text, DdlDomain.SelectedValue);
if (obj.Do_Transaction(sql1))
{
LoadDomainGrid();
loadDomainOnDdl();
}
TxtDomainName.Text = "";
BtnDomainSave.Text = "Save";
}

}

public void loadDomainOnDdl()
{
string sql = string.Format("select * from DomainMaster order by DomainName");
DataTable dt = new DataTable();
dt = obj.Do_NonTransaction(sql);
DataTable newdt = new DataTable();
newdt.Columns.Add("DomainName");
newdt.Columns.Add("DomainId");
foreach (DataRow r in dt.Rows)
{
DataRow row = newdt.NewRow();
row["DomainName"] = r["DomainName"].ToString();
row["DomainId"] = r["DomainId"].ToString();
newdt.Rows.Add(row);
}
DdlDomain.DataSource = newdt;
DdlDomain.DataTextField = "DomainName";
DdlDomain.DataValueField = "DomainId";
DdlDomain.DataBind();

}

private void LoadDomainGrid()
{
string sql_domain = string.Format("select * from DomainMaster order by DomainName");
DataTable Dt_domain = new DataTable();
Dt_domain = obj.Do_NonTransaction(sql_domain);
GrdDomain.DataSource = Dt_domain;
GrdDomain.DataBind();
}

protected void LnkDomainEdit_Click(object sender, EventArgs e)
{
ModalPopupDomain.Show();

BtnDomainSave.Text = "Update";
domainid = int.Parse(((LinkButton)sender).CommandArgument);
GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent;
TxtDomainName.Text = row.Cells[1].Text;
}


protected void Delete_Click(object sender, EventArgs e)
{
try
{
ModalPopupDomain.Show();
string sql_delete = string.Format("Delete from DomainMaster where DomainId=''{0}''", DdlDomain.SelectedValue);
if (obj.Do_Transaction(sql_delete))
{
LoadDomainGrid();
loadDomainOnDdl();
}
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", "alert('' There is no Domain to delete !'')", true);
}
}

受保护的空白Page_Load(对象发送者，EventArgs e)
{
如果(！IsPostBack)
{
LoadDomainGrid();
loadDomainOnDdl();
}
}

受保护的void BtnDomainSave_Click(对象发送者，EventArgs e)
{
ModalPopupDomain.Show();
如果(BtnDomainSave.Text ==保存")
{
字符串sql = string.Format(插入DomainMaster(DomainName)values(''{0}'')"，TxtDomainName.Text);
如果(obj.Do_Transaction(sql))
{
LoadDomainGrid();
loadDomainOnDdl();
DdlDomain.SelectedIndex = DdlDomain.Items.IndexOf(new ListItem(TxtDomainName.Text));
TxtDomainName.Text =";

}
}
其他
{
字符串sql1 = string.Format("update DomainMaster set DomainName =""{0}"其中DomainId =" {1}"，TxtDomainName.Text，DdlDomain.SelectedValue);
如果(obj.Do_Transaction(sql1))
{
LoadDomainGrid();
loadDomainOnDdl();
}
TxtDomainName.Text =";
BtnDomainSave.Text =保存";
}

}

公共无效loadDomainOnDdl()
{
字符串sql = string.Format(从DomainMaster按DomainName顺序选择*");
DataTable dt = new DataTable();
dt = obj.Do_NonTransaction(sql);
DataTable newdt = new DataTable();
newdt.Columns.Add("DomainName");
newdt.Columns.Add("DomainId");
foreach(dt.rows中的DataRow r)
{
DataRow行= newdt.NewRow();
row ["DomainName"] = r ["DomainName"].ToString();
row ["DomainId"] = r ["DomainId"].ToString();
newdt.Rows.Add(row);
}
DdlDomain.DataSource = newdt;
DdlDomain.DataTextField ="DomainName";
DdlDomain.DataValueField ="DomainId";
DdlDomain.DataBind();

}

私有void LoadDomainGrid()
{
字符串sql_domain = string.Format(从DomainMaster按DomainName顺序选择*");
DataTable Dt_domain =新的DataTable();
Dt_domain = obj.Do_NonTransaction(sql_domain);
GrdDomain.DataSource = Dt_domain;
GrdDomain.DataBind();
}

受保护的void LnkDomainEdit_Click(对象发送者，EventArgs e)
{
ModalPopupDomain.Show();

BtnDomainSave.Text =更新";
domainid = int.Parse((((LinkBut​​ton)sender).CommandArgument);
GridViewRow row =(GridViewRow)((LinkBut​​ton)sender).Parent.Parent;
TxtDomainName.Text = row.Cells [1] .Text;
}


受保护的void Delete_Click(对象发送者，EventArgs e)
{
试试
{
ModalPopupDomain.Show();
字符串sql_delete = string.Format(从DomainMaster删除，其中DomainId =''{0}''"，DdlDomain.SelectedValue);
如果(obj.Do_Transaction(sql_delete))
{
LoadDomainGrid();
loadDomainOnDdl();
}
}
赶上
{
ScriptManager.RegisterStartupScript(this，this.GetType()，"key"，"alert("没有要删除的域！)"，true);
}
}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadDomainGrid();
loadDomainOnDdl();
}
}

protected void BtnDomainSave_Click(object sender, EventArgs e)
{
ModalPopupDomain.Show();
if (BtnDomainSave.Text == "Save")
{
string sql = string.Format("insert into DomainMaster(DomainName) values(''{0}'')", TxtDomainName.Text);
if (obj.Do_Transaction(sql))
{
LoadDomainGrid();
loadDomainOnDdl();
DdlDomain.SelectedIndex = DdlDomain.Items.IndexOf(new ListItem(TxtDomainName.Text));
TxtDomainName.Text = "";

}
}
else
{
string sql1 = string.Format("update DomainMaster set DomainName=''{0}'' where DomainId=''{1}''", TxtDomainName.Text, DdlDomain.SelectedValue);
if (obj.Do_Transaction(sql1))
{
LoadDomainGrid();
loadDomainOnDdl();
}
TxtDomainName.Text = "";
BtnDomainSave.Text = "Save";
}

}

public void loadDomainOnDdl()
{
string sql = string.Format("select * from DomainMaster order by DomainName");
DataTable dt = new DataTable();
dt = obj.Do_NonTransaction(sql);
DataTable newdt = new DataTable();
newdt.Columns.Add("DomainName");
newdt.Columns.Add("DomainId");
foreach (DataRow r in dt.Rows)
{
DataRow row = newdt.NewRow();
row["DomainName"] = r["DomainName"].ToString();
row["DomainId"] = r["DomainId"].ToString();
newdt.Rows.Add(row);
}
DdlDomain.DataSource = newdt;
DdlDomain.DataTextField = "DomainName";
DdlDomain.DataValueField = "DomainId";
DdlDomain.DataBind();

}

private void LoadDomainGrid()
{
string sql_domain = string.Format("select * from DomainMaster order by DomainName");
DataTable Dt_domain = new DataTable();
Dt_domain = obj.Do_NonTransaction(sql_domain);
GrdDomain.DataSource = Dt_domain;
GrdDomain.DataBind();
}

protected void LnkDomainEdit_Click(object sender, EventArgs e)
{
ModalPopupDomain.Show();

BtnDomainSave.Text = "Update";
domainid = int.Parse(((LinkButton)sender).CommandArgument);
GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent;
TxtDomainName.Text = row.Cells[1].Text;
}


protected void Delete_Click(object sender, EventArgs e)
{
try
{
ModalPopupDomain.Show();
string sql_delete = string.Format("Delete from DomainMaster where DomainId=''{0}''", DdlDomain.SelectedValue);
if (obj.Do_Transaction(sql_delete))
{
LoadDomainGrid();
loadDomainOnDdl();
}
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", "alert('' There is no Domain to delete !'')", true);
}
}

这篇关于在单个弹出窗口中使用ModalpopupExtender是否可以执行插入更新删除操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！