public class User:
SRMS.IDataAccessLayer.IUser
{
#region IUser 成员
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
private const string ValidateUserSQL
= "select UserId from users where UserName=@username and Password=@password"; //定义参数
private const string usernameParameter = "@username";
private const string passwordParameter = "@password";
public bool ValidateUser(string username, string password)
{
//定义参数对象
MySqlParameter pName = new MySqlParameter(usernameParameter, MySqlDbType.VarChar, 50);
MySqlParameter pPwd = new MySqlParameter(passwordParameter, MySqlDbType.VarChar, 50); //为对象赋值
pName.Value = username;
pPwd.Value = password; //执行sql语句
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
MySqlCommand command = new MySqlCommand(ValidateUserSQL, connection);
connection.Open(); command.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = password; object result= command.ExecuteScalar(); //如果有查到,返回值就不为null
return result != null; }
}
//////////////////////////////////////////我用的是MySql数据库
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString; 错误提示:未将对象引用到对象的实例配置文件时这样写的:
<connectionStrings>
<add name="conn" connectionString="host=127.0.0.1;database=mysrms;uid=root;pwd=123;"/>
</connectionStrings>
SRMS.IDataAccessLayer.IUser
{
#region IUser 成员
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
private const string ValidateUserSQL
= "select UserId from users where UserName=@username and Password=@password"; //定义参数
private const string usernameParameter = "@username";
private const string passwordParameter = "@password";
public bool ValidateUser(string username, string password)
{
//定义参数对象
MySqlParameter pName = new MySqlParameter(usernameParameter, MySqlDbType.VarChar, 50);
MySqlParameter pPwd = new MySqlParameter(passwordParameter, MySqlDbType.VarChar, 50); //为对象赋值
pName.Value = username;
pPwd.Value = password; //执行sql语句
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
MySqlCommand command = new MySqlCommand(ValidateUserSQL, connection);
connection.Open(); command.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = password; object result= command.ExecuteScalar(); //如果有查到,返回值就不为null
return result != null; }
}
//////////////////////////////////////////我用的是MySql数据库
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString; 错误提示:未将对象引用到对象的实例配置文件时这样写的:
<connectionStrings>
<add name="conn" connectionString="host=127.0.0.1;database=mysrms;uid=root;pwd=123;"/>
</connectionStrings>
解决方案 »
- C#两个关于listview的问题
- 求一个函数 把日期转换成16进制(正则函数都行)
- 下载网页数据写入文件后出现乱码,高手指教!
- C#中关于office库的引用问题
- 怎么在窗体运行的时候自动登录到另一个窗体。
- javascript问题:正则表达式的写法
- c# 网页图片自动交替播放
- 求解C#字典ConcurrentDictionary.ContainsKey(key)为true之后,ConcurrentDictionary[key]报不存在
- 枚举的遍历
- 关于查看API User32.dll 方法的问题
- datagridview搜索定位的问题!
- web服务、ado.net数据服务、http端点、wcf
app.config<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="conn" connectionString="host=127.0.0.1;database=mysrms;uid=root;pwd=123;"/>
</connectionStrings>
</configuration>先保证连接字符串无误再说别的吧
<add name="conn" connectionString="host=127.0.0.1;database=mysrms;uid=root;pwd=123;"/>
</connectionStrings>
这样写<connectionStrings>
<add name="conn"
connectionString="server=localhost;User Id=root;password=123;Persist Security Info=True;database=mysrms"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>