在C#中检测数据库中一条记录是否存在可以使用SQL
语句的COUNT
或EXISTS
,如:
SELECT * from users where user_name like 'Adam' AND password like '123456'
C#操作代码:
int userCount = (int) sqlCommand.ExecuteScalar();
if(userCount > 0)
// user exists ....
在C#中检测数据库中一条记录是否存在可以使用SQL
语句的COUNT
或EXISTS
,如:
SELECT * from users where user_name like 'Adam' AND password like '123456'
C#操作代码:
int userCount = (int) sqlCommand.ExecuteScalar();
if(userCount > 0)
// user exists ....