首先我用的是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);
}
上面就是检索数据的最基本方法拉;