SQL查询登录ID的条件为" WHERE ".

1.首先在登录屏幕上接受用户的LoginID和密码.
2.借助登录ID从数据库中获取记录.
3.如果没有记录，则显示消息您尚未创建帐户".
4.如果记录存在，则从UserTable中选择密码，其中UserName =" UserName""
5.如果不存在任何记录，则显示消息密码错误，请重试".

检查以下链接， c#中的登录页面 [

Where is "WHERE" condition in your SQL Query for login ID.

1. First accept LoginID and Password from user on login screen.
2. with the help of Login ID fetch record from database.
3. if no record exist then show message "you have not created your account".
4. if record exist then, "Select Password From UserTable Where UserName = ''UserName''"
5. if no record exist then show message "Wrong Password, Please Try Again".

check following link, login page in c#[^]

"SELECT userName,password FROM Login where userName='" + txtUserName.Text + "' AND password='" + txtPassword.Text + "'"

然后检查dt.rows.count值是否为0，然后登录失败，如果它获得行，则登录成功

Then check dt.rows.count value if it is 0 then login fail and if it gets row then login successfully