- -今天加班所以偷懒中,另在酝酿一个新的项目,名字没有想好,主要功能保密哈,进度30%,等做好了公布原代码,给个提示圆子里不是有个兄弟做了个模拟dos动东西么?
//--反写
//--反写
SqlCommandBuilder sqlCommandBuilder1 = new SqlCommandBuilder ( sqlDataAdapter1 ) ;
//以sqlDataAdapter1为参数来初始化SqlCommandBuilder实例
dsDataSet1.Tables["Customers"].Rows[0].Delete ( ) ;
//删除DataSet中删除数据表Customers中第一行数据
sqlDataAdapter1.Update ( dsDataSet1 ,"Customers" ) ;
//调用Update方法,以DataSet中的数据更新从数据库
dsDataSet1.Tables["Customers"].AcceptChanges ( ) ;
//以sqlDataAdapter1为参数来初始化SqlCommandBuilder实例
dsDataSet1.Tables["Customers"].Rows[0].Delete ( ) ;
//删除DataSet中删除数据表Customers中第一行数据
sqlDataAdapter1.Update ( dsDataSet1 ,"Customers" ) ;
//调用Update方法,以DataSet中的数据更新从数据库
dsDataSet1.Tables["Customers"].AcceptChanges ( ) ;
//--事物
SqlConnection myConnection = new SqlConnection("Server=(local);Initial Catalog=Northwind;uid=sa;pwd=111;");
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
// 为事务创建一个命令
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (110, 'Description')";
myCommand.ExecuteNonQuery();
//myTrans.Commit();
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (111, 'Description')";
myCommand.ExecuteNonQuery();
//提交,作用是吧所有的执行语句,一起执行如果有错误责抛出
myTrans.Commit();
Response.Write("成功写入记录!");
}
catch(Exception Ex)
{
//回滚数据
myTrans.Rollback();
Response.Write(Ex.ToString());
Response.Write("写入数据库失败!");
}
finally
{
myConnection.Close();
}
}
}
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
// 为事务创建一个命令
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (110, 'Description')";
myCommand.ExecuteNonQuery();
//myTrans.Commit();
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (111, 'Description')";
myCommand.ExecuteNonQuery();
//提交,作用是吧所有的执行语句,一起执行如果有错误责抛出
myTrans.Commit();
Response.Write("成功写入记录!");
}
catch(Exception Ex)
{
//回滚数据
myTrans.Rollback();
Response.Write(Ex.ToString());
Response.Write("写入数据库失败!");
}
finally
{
myConnection.Close();
}
}
}
//建立约束
SqlConnection mysqlcon=new SqlConnection ("server=.; uid=sa;pwd=sa; database=northwind");
SqlDataAdapter myDataAdapter1 = new SqlDataAdapter("select * from customers", mysqlcon);
SqlDataAdapter myDataAdapter2 = new SqlDataAdapter("select * from orders", mysqlcon);
mysqlcon.Open();
DataSet dataset1=new DataSet();
myDataAdapter1.Fill(dataset1,” customers”);
myDataAdapter2.Fill(dataset1,” orders”);主要建约束的表------------------主要建行------------列-----------------------------
DataRelation rr=dataset1. Relations.add(“customers”,dataset1.Tables[” customers”].Columns[“customerid”],
/**////外建约束
dataset1.Tables[”orders”].Columns[“customerid”]);
foreach(Datarow prow in dataset1.Tables[”customers”].Rows)
{//外行主建循环
Response.Write(prow[“customerid”]);
foreach(Datarow crow in prow.GetChildRows(rr))
内行外建循环
Response.Write(crow[“ordid”]);
}
SqlConnection mysqlcon=new SqlConnection ("server=.; uid=sa;pwd=sa; database=northwind");
SqlDataAdapter myDataAdapter1 = new SqlDataAdapter("select * from customers", mysqlcon);
SqlDataAdapter myDataAdapter2 = new SqlDataAdapter("select * from orders", mysqlcon);
mysqlcon.Open();
DataSet dataset1=new DataSet();
myDataAdapter1.Fill(dataset1,” customers”);
myDataAdapter2.Fill(dataset1,” orders”);主要建约束的表------------------主要建行------------列-----------------------------
DataRelation rr=dataset1. Relations.add(“customers”,dataset1.Tables[” customers”].Columns[“customerid”],
/**////外建约束
dataset1.Tables[”orders”].Columns[“customerid”]);
foreach(Datarow prow in dataset1.Tables[”customers”].Rows)
{//外行主建循环
Response.Write(prow[“customerid”]);
foreach(Datarow crow in prow.GetChildRows(rr))
内行外建循环
Response.Write(crow[“ordid”]);
}