首先我用的是SQL 2000和VS2005,下面開始吧,數據庫存放用戶的數據庫叫tbUser,當點擊登陸界面
的登陸按鈕時就會對數據庫進行檢索。雙擊按鈕開始寫碼吧....
protected void btn_Login_Click(object sender, EventArgs e)
{
string s = "@server = james; database = tbUser; uid = JJ ; pwd = ""; ";
using (SqlConnection conn = new Sqlconnection(s)){
conn.open;
using (SqlCommand cmd = new SqlCommand()){
cmd.Connection = conn;
cmd.CommandText = "Select count(*) from tbUser where USERName=@UserName"
cmd.Parameters.AddWithValue("UserName", tb_UserName.Text);
}
上面就是檢索數據的最基本方法拉;