代码段（逐步添加）

1. 关闭窗体前提示

         private   void  BeforeClosing( object  sender, FormClosingEventArgs e)
         ... {
            if (MessageBox.Show("是否退出?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
            ...{
                e.Cancel = true;
            }
        }

 

2.存储过程

//（取前十个数据）

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

//执行存储过程

While (DR.Read())

{
.......

    Sql =s tring.Format( " Execute sprocDeletePeopleByID {0} " ,ID);
SqlCmd = new  SqlCommand(Sql,dbConn);
Rows = SqlCmd.ExecuteNoQuery(Sql);
}

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

Create   Procedure  sprocDeletePeopleByID(  @ID   int )
As
Delete   *   From  People
Where  PeopleID = @ID
Return  ( @@RowCount )