1，創(chuàng)建存儲(chǔ)過(guò)程
create proc Pro_Login
(
@UserName nvarchar(10),
@PassWord nvarchar(10)
)
as
select * from [User] UserName=@UserName and PassWord=@PassWord
2，通過(guò)類(lèi)是實(shí)現(xiàn)配置數(shù)據(jù)庫(kù)字符串連接
class ConnectionString
{
public static string conStr = "Data Source=MyLove-PC;Initial Catalog=data;Integrated Security=True";
}
3，實(shí)現(xiàn)登錄功能
#region
//連接數(shù)據(jù)庫(kù)配置字符串
using (SqlConnection con = new SqlConnection(ConnectionString.conStr))
{
con.Open();//打開(kāi)數(shù)據(jù)庫(kù)
//調(diào)用存儲(chǔ)過(guò)程
using (SqlCommand cmd = new SqlCommand("Pro_Login", con))
{
//把文本框的值作為參數(shù)傳給存儲(chǔ)過(guò)程
cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 10).Value = textBox1.Text.Trim();
cmd.Parameters.Add("@PassWord", SqlDbType.VarChar, 10).Value = textBox2.Text.Trim();
//通過(guò)存儲(chǔ)過(guò)程的方式執(zhí)行
cmd.CommandType = CommandType.StoredProcedure;
//開(kāi)始讀取數(shù)據(jù)
using (SqlDataReader dr = cmd.ExecuteReader())
{
//如果讀到用戶(hù)名和密碼，則調(diào)轉(zhuǎn)到界面Form2
if (dr.Read())
{
this.Hide();
Form2 f2 = new Form2();
f2.Show();
}
//否則，提示錯(cuò)誤
else
{
MessageBox.Show("用戶(hù)名或者密碼錯(cuò)誤", "請(qǐng)重新輸入", MessageBoxButtons.OK);
textBox1.Clear();
textBox2.Clear();
textBox1.Focus();
}
}
}
}
#endregion
4，界面測(cè)試
