SqlConnection conn = new SqlConnection("Persist Security Info=False;User ID=sa;Password=;Initial Catalog=Student;Server=(local)");
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from T_Users where UserName=@UserName";
cmd.Parameters.Add(new SqlParameter("UserName", this.txtUsername.Text.Trim()));
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
string dbpassword = reader.GetString(reader.GetOrdinal("Password"));
if (dbpassword == this.txtPassword.Text.Trim())
{
this.lblResults.Text = "登錄成功！";
}
else { this.lblResults.Text = "登陸失敗"; }
}
else
{
this.lblResults.Text = "用戶名不存在";
}
}
}
}
uj5u.com熱心網友回復：
沒看到這種寫法的，學習了一般偶都是直接使用SQL陳述句
string ls_name
string ls_pass
string ls_temp
ls_name = sle_name.text //用戶輸入的登錄名
ls_pass = sle_pass.text //用戶輸入的密碼
SELECT PassWord
INTO :ls_temp
FROM T_Users
WHERE UserName=:ls_name AND ;
if SQLCA.SQLCode = -1 then
MessageBox("提示","資料庫錯誤，登錄失敗！" + "~r~n" + "錯誤資訊：" + SQLCA.SQLErrText)
else
if SQLCA.SQLCode = 100 then
MessageBox("提示","錯誤的登錄名")
else
if IsNull(ls_temp) then ls_tmep = ""
if IsNull(ls_pass) then ls_pass = ""
if ls_temp <> ls_pass then
MessageBox("提示","錯誤的口令")
else
MessageBox("提示","登錄成功")
end if
end if
end if
uj5u.com熱心網友回復：
樓主應該發貼到C#版吧，cmd.CommandText = "select * from T_Users where UserName=@UserName";
應該是這里有問題，你把select * from 換成select password from 試試。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/71855.html
標籤：數據庫相關
上一篇：pb存取圖片的問題
下一篇：pb菜鳥求助