IDC资讯中心 程序可以直接拿来使用，运行通过。 —————————————————- <%@ Page Language=”c#” debug=”true” %> <html> ds=new DataSet(); MyDataGrid.DataSource=ds.Tables[“suppliers”].DefaultView; void MyDataGrid_Delete(Object sender,DataGridCommandEventArgs e) SqlDataAdapter myDataAdapter1=new SqlDataAdapter(); SqlDataAdapter myDataAdapter2=new SqlDataAdapter(); ds=new DataSet(); CreateConstraint(); int index=(int)e.Item.ItemIndex; myDataAdapter1.Update(ds,”suppliers”); MyDataGrid2.DataSource=ds.Tables[“products”].DefaultView; void CreateConstraint() parentColumn = ds.Tables[“suppliers”].Columns[“supplierID”]; myForeignKeyConstraint.DeleteRule = Rule.Cascade ; ds.Tables[“products”].Constraints.Add(myForeignKeyConstraint) ; </script> <Columns> </ASP:DataGrid> <hr> </form>
testconstraint.aspx
—————————————————-
<%@ Import Namespace=”System.Data” %>
<%@ Import Namespace=”System.Data.SqlClient” %>
<head>
<script language=”c#” runat=”server”>
public DataSet ds;
void Page_Load(Object sender,EventArgs e)
{
if(!IsPostBack)
{
SqlConnection myConnection = new SqlConnection(“server=(local);database=northwind;Trusted_Connection=yes”);
SqlDataAdapter myDataAdapter1=new SqlDataAdapter(“select * from suppliers”,myConnection);
SqlDataAdapter myDataAdapter2=new SqlDataAdapter(“select * from products”,myConnection);
myDataAdapter1.Fill(ds,”suppliers”);
myDataAdapter2.Fill(ds,”products”);
MyDataGrid.DataBind();
MyDataGrid2.DataSource=ds.Tables[“products”].DefaultView;
MyDataGrid2.DataBind();
}
}
{
String conn=”server=(local);database=northwind;Trusted_Connection=yes”;
String selectCommandText1=”select * from suppliers”;
String selectCommandText2=”select * from products”;
myDataAdapter1.SelectCommand=new SqlCommand();
myDataAdapter1.SelectCommand.CommandText=selectCommandText1;
myDataAdapter1.SelectCommand.Connection=new SqlConnection(conn);
myDataAdapter2.SelectCommand=new SqlCommand();
myDataAdapter2.SelectCommand.CommandText=selectCommandText2;
myDataAdapter2.SelectCommand.Connection=new SqlConnection(conn);
myDataAdapter1.Fill(ds,”suppliers”);
myDataAdapter2.Fill(ds,”products”);
ds.Tables[“suppliers”].Rows[index].Delete();
ds.Tables[“suppliers”].AcceptChanges();
MyDataGrid.DataSource=ds.Tables[“suppliers”].DefaultView;
MyDataGrid.DataBind();
MyDataGrid2.DataBind();
}
{
DataColumn parentColumn,childColumn;
ForeignKeyConstraint myForeignKeyConstraint;
childColumn = ds.Tables[“products”].Columns[“supplierID”];
myForeignKeyConstraint = new ForeignKeyConstraint(“SupplierForeignKeyConstraint”, parentColumn, childColumn);
myForeignKeyConstraint.UpdateRule = Rule.Cascade ;
myForeignKeyConstraint.AcceptRejectRule = AcceptRejectRule.Cascade ;
ds.EnforceConstraints =true ;
}
</head>
<body>
<form runat=”server”>
<ASP:DataGrid id=”MyDataGrid” runat=”server”
Width=”800″
BackColor=”#ccccff”
BorderColor=”black”
ShowFooter=”false”
CellPadding=3
CellSpacing=”0″
Font-Name=”Verdana”
Font-Size=”8pt”
HeaderStyle-BackColor=”#aaaadd”
OnDeleteCommand=”MyDataGrid_Delete”
DataKeyField=”supplierid”
>
<asp:ButtonColumn Text=”Delete Employee” CommandName=”Delete”/>
</Columns>
<ASP:DataGrid id=”MyDataGrid2″ runat=”server”
Width=”800″
BackColor=”#ccccff”
BorderColor=”black”
ShowFooter=”false”
CellPadding=3
CellSpacing=”0″
Font-Name=”Verdana”
Font-Size=”8pt”
HeaderStyle-BackColor=”#aaaadd”
/>
</body>
</html>
在dataset中建立外键约束_asp.net实例
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com 特别注意：本站所有转载文章言论不代表本站观点！ 本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。未经允许不得转载：IDC资讯中心 » 在dataset中建立外键约束_asp.net实例
相关推荐
- 暂无文章
