public SqlDataReader GetUserLoginByProc(string sUserName,string sPassword)
 {
  ///創(chuàng)建鏈接
  SqlConnection myConnection = new SqlConnection(
   ConfigurationManager.ConnectionStrings["數(shù)據(jù)庫(kù)連接字符"].ConnectionString);

  ///創(chuàng)建Command
  SqlCommand myCommand = new SqlCommand("Pr_GetUserLogin",myConnection);
  ///設(shè)置為執(zhí)行存儲(chǔ)過(guò)程
  myCommand.CommandType = CommandType.StoredProcedure;

  ///添加存儲(chǔ)過(guò)程的參數(shù)
  SqlParameter pUserName = new SqlParameter("@UserName",SqlDbType.VarChar,32);
  pUserName.Value = sUserName;
  myCommand.Parameters.Add(pUserName);

  SqlParameter pPassword = new SqlParameter("@Password",SqlDbType.VarChar,255);
  pPassword.Value = sPassword;
  myCommand.Parameters.Add(pPassword);

  ///定義DataReader
  SqlDataReader dr = null;
  try
  {
   ///打開鏈接
   myConnection.Open();
   ///讀取數(shù)據(jù)
   dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
  }
  catch(SqlException ex)
  {
   ///拋出異常
   throw new Exception(ex.Message,ex);
  }
  ///返回DataReader
  return dr;
 }