执行SP一例

 public class User
 {
  public static void Login
   (
   string Login,
   string Password,
   out int ID,
   string Connect,
   ref string Ex
   )
  {
   ID = 0;

   #region 输入参数
   string P = "P_User_Login";
   XSD.User_Login xsd = new XSD.User_Login();
   DataRow drIN = xsd.Tables["IN"].NewRow();

   drIN["Login"] = Login;
   drIN["Password"] = Password;

   xsd.Tables["IN"].Rows.Add( drIN );
   #endregion

   #region 执行
   DataProxy.ExecP( P, xsd, Connect, ref Ex );
   
   if( Ex != string.Empty )
   {
    return;
   }
   #endregion

   if( xsd.Tables["OUT"] != null && xsd.Tables["OUT"].Rows.Count > 0 )
   {
    ID = Convert.ToInt32( xsd.Tables["OUT"].Rows[0]["ID"] );
   }
  }
 }