使用存儲(chǔ)過程實(shí)現(xiàn)用戶登錄(含代碼)_.Net教程

教程Tag：暫無Tag,歡迎添加,賺取U幣!

推薦：aspx頁面彈出窗口代碼大全
//關(guān)閉,父窗口彈出對(duì)話框,子窗口直接關(guān)閉 this.Response.Write(scriptlanguage=javascriptwindow.close();/script); //關(guān)閉,父窗口和子窗口都不彈出對(duì)話框,直接關(guān)閉 this.Response.Write(script); this.Response.Write({top.opener=null;top.close();}

程序代碼：

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ǔ)過程
  myCommand.CommandType = CommandType.StoredProcedure;

  ///添加存儲(chǔ)過程的參數(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;
}

存儲(chǔ)過程代碼：

CREATE PROCEDURE Pr_GetUserLogin
(
@UserName varchar(32),
@Password varchar(255)
)

AS

SELECT
UserID
FROM
Users
WHERE
UserName = @UserName AND Password = @Password

GO

分享：ASPX頁面出現(xiàn)亂碼的解決辦法
1、在web.config中加入：globalization requestEncoding=GB2312 responseEncoding=GB2312 culture=zh-CN fileEncoding=GB2312/ 2、在%@ Page...中加入：codepage=936 3、meta http-equiv=Content-Type content=text/html; charset=gb2312 4、?xml