Initial Catalog=Test;Integrated Security=True"))//這裏是妳的數據庫的鏈接字符串
{
conn.Open(); / / 打開數據庫
using (SqlCommand cmd = conn.CreateCommand()) // using 目的是以後不需要conn.closed
{
cmd.CommandText="select *from denglu where UserName='"+TextBox1.text+"'"; //TestBox1是妳TestBox的Name
using(SqlDataReader reader=cmd.ExecuteReader())
{
if(reader.Read())
{
string dbpassword =reader.GetString(reader.GetOrdinal("UserPassward")); //UserPassward 是妳數據庫裏存在的密碼 if (dbpassword == password) // 進行密碼的校驗 註意:數據庫中字段的類型!!
response.Write("yes"); // 可以用Java腳本編寫彈出窗體
else
{
response.Write("No"); }
}
else
{
response.Write("登錄失敗"); }