GridView嵌套GridView 级联删除(使用SqlDataSource删除版本)
来源:互联网 发布:网站美工都做什么 编辑:程序博客网 时间:2024/06/16 19:58
GridView嵌套GridView,对子GridView及父GridView级联删除的问题,使用SqlDataSource删除版本
- <%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewNesting.aspx.cs" Inherits="GridViewNesting" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" >
- <head runat="server">
- <title>GridViewNesting</title>
- </head>
- <body>
- <form id="form1" runat="server">
- <div>
- <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound" >
- <Columns>
- <asp:CommandField ShowEditButton="True" />
- <asp:CommandField ShowDeleteButton="True" />
- <asp:TemplateField HeaderText="au_id" >
- <ItemTemplate>
- <asp:Label id="Label1" runat="server" Text='<%# Eval("au_id")%>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="au_lname">
- <ItemTemplate>
- <asp:Label id="Label2" runat="server" Text='<%# Eval("au_lname")%>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="titleDetail">
- <ItemTemplate>
- <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id,title_id" DataSourceID="SqlDataSource2">
- <Columns>
- <asp:CommandField ShowEditButton="True" />
- <asp:CommandField ShowDeleteButton="True" />
- <asp:TemplateField HeaderText="title_id" >
- <ItemTemplate>
- <asp:Label id="Label1" runat="server" Text='<%# Eval("title_id")%>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="au_ord">
- <ItemTemplate>
- <asp:Label id="Label2" runat="server" Text='<%# Eval("au_ord")%>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- </Columns>
- </asp:GridView>
- <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=./sqlexpress;Initial Catalog=pubs;Integrated Security=True"
- ProviderName="System.Data.SqlClient" SelectCommand="select au_id, title_id, au_ord from titleauthor where au_id = @au_id" DeleteCommand="delete from titleauthor where au_id = @au_id and title_id = @title_id">
- <SelectParameters>
- <asp:Parameter Name="au_id" />
- </SelectParameters>
- <DeleteParameters>
- <asp:Parameter Name="au_id" />
- <asp:Parameter Name="title_id" />
- </DeleteParameters>
- </asp:SqlDataSource>
- </ItemTemplate>
- </asp:TemplateField>
- </Columns>
- </asp:GridView>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=./sqlexpress;Initial Catalog=pubs;Integrated Security=True"
- ProviderName="System.Data.SqlClient" SelectCommand="select au_id, au_lname from authors" DeleteCommand="delete from titleauthor where au_id = @au_id;delete from authors where au_id = @au_id">
- <DeleteParameters>
- <asp:Parameter Name="au_id" />
- </DeleteParameters>
- </asp:SqlDataSource>
- </div>
- </form>
- </body>
- </html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewNesting.aspx.cs" Inherits="GridViewNesting" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>GridViewNesting</title></head><body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound" > <Columns> <asp:CommandField ShowEditButton="True" /> <asp:CommandField ShowDeleteButton="True" /> <asp:TemplateField HeaderText="au_id" > <ItemTemplate> <asp:Label id="Label1" runat="server" Text='<%# Eval("au_id")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="au_lname"> <ItemTemplate> <asp:Label id="Label2" runat="server" Text='<%# Eval("au_lname")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="titleDetail"> <ItemTemplate> <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id,title_id" DataSourceID="SqlDataSource2"> <Columns> <asp:CommandField ShowEditButton="True" /> <asp:CommandField ShowDeleteButton="True" /> <asp:TemplateField HeaderText="title_id" > <ItemTemplate> <asp:Label id="Label1" runat="server" Text='<%# Eval("title_id")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="au_ord"> <ItemTemplate> <asp:Label id="Label2" runat="server" Text='<%# Eval("au_ord")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=./sqlexpress;Initial Catalog=pubs;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="select au_id, title_id, au_ord from titleauthor where au_id = @au_id" DeleteCommand="delete from titleauthor where au_id = @au_id and title_id = @title_id"> <SelectParameters> <asp:Parameter Name="au_id" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="au_id" /> <asp:Parameter Name="title_id" /> </DeleteParameters> </asp:SqlDataSource> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=./sqlexpress;Initial Catalog=pubs;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="select au_id, au_lname from authors" DeleteCommand="delete from titleauthor where au_id = @au_id;delete from authors where au_id = @au_id"> <DeleteParameters> <asp:Parameter Name="au_id" /> </DeleteParameters> </asp:SqlDataSource> </div> </form></body></html>
aspx.cs
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- public partial class GridViewNesting : System.Web.UI.Page
- {
- private void Page_Load(object sender, System.EventArgs e)
- {
- }
- protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
- {
- SqlDataSource sqlDataSource2;
- if (e.Row.RowType == DataControlRowType.DataRow)
- {
- sqlDataSource2 = e.Row.FindControl("SqlDataSource2") as SqlDataSource;
- if (sqlDataSource2 != null)
- {
- sqlDataSource2.SelectParameters["au_id"].DefaultValue = (e.Row.DataItem as DataRowView)["au_id"].ToString();
- }
- }
- }
- }
- GridView嵌套GridView 级联删除(2.使用SqlDataSource删除版本)
- GridView嵌套GridView 级联删除(使用SqlDataSource删除版本)
- GridView嵌套GridView 级联删除(1.纯代码删除版本)
- GridView嵌套GridView 级联删除(纯代码删除版本)
- GridView嵌套GridView 级联删除(1.纯代码删除版本)
- Gridview+sqldatasource使用注意事项
- gridview删除
- gridview----删除
- gridView和sqlDataSource的使用
- 使用sqldatasource动态绑定gridview
- 使用commandfield删除、修改gridview
- 使用GridView添加,删除,编辑记录
- GridView使用技巧之一 全选 删除 排序
- SQL_修改删除与GridView配合使用
- 使用AJAX进行GridView行删除
- asp:GridView 使用增加删除行
- GridView + SqlDataSource + 分页+ 搜索
- SqlDataSource GridView 显示分类
- DataList嵌套DataList(使用DataRelation实现 纯代码)
- Birt小试
- DataList嵌套DataList(使用SqlDataSource实现)
- JavaScript 中如何正确替换回车换行符
- java学习笔记
- GridView嵌套GridView 级联删除(使用SqlDataSource删除版本)
- 外企面试官们爱提的十个问题
- DataList绑定数据到泛型类(Dictionary)
- GPS坐标系统和时间系统
- TCP/IP 协议故障解决一例
- GridView自定义分页的四种存储过程
- SQL语句大全
- 新的开始
- Repeater自定义分页