操作DataRow记录

 =====从存储过里返回================

public DataRow Retrieve(int userID)

         {

              SqlParameter[] parameters=

                   {

                       new SqlParameter("@UserID",SqlDbType.Int,4)

                   };

              parameters[0].Value=userID;

 

              using(DataSet users=RunProcedure("sp_Accounts_GetUserDetails",parameters,"Users"))

              {

                   return users.Tables[0].Rows[0];

              }

         }

=========================读取DataRow记录=======================================

         private void LoadFromID()

         {

              Data.User dataUser=new Data.User(moduleSetting.ConnectionString);

              DataRow userRow=dataUser.Retrieve(userID);

 

            account=(string)userRow["Account"];

              password=(byte[])userRow["Password"];

              userName=(string)userRow["UserName"];

              telephoneNumber=(string)userRow["TelephoneNumber"];

              email=(string)userRow["Email"];

              passQuestion=(string)userRow["PassQuestion"];

              passAnswer=(byte[])userRow["PassAnswer"];

              address=(string)userRow["Address"];

         }