Question

C# SQL数据库连接字符串 代码问题

string s = "select count(*) from Admin where LoginId='" + userName + "'and LoginPwd='" + pwd + "'"; 这段代码如何改成格式字符串的形式，就是去掉加号，改成{n}的格式 谢谢

Answer 1

string
s
=
string.Format("select
count(*)
from
Admin
where
LoginId=
'{0}'
and
LoginPwd=
'{1}'",userName,pwd);