- 关闭窗体前提示









2.存储过程

Create Procedure SelectTenPeople
AS
Set RowCount=10
Select * From People
Where Sex='男' order by PeopleID
Desc








While (DR.Read())
{
.......
.......
Sql=string.Format("Execute sprocDeletePeopleByID {0}",ID);
SqlCmd=new SqlCommand(Sql,dbConn);
Rows=SqlCmd.ExecuteNoQuery(Sql);
}


}

//删除人员,并返回记录行数




