连不上mysql数据库(
未将对象引用到对象的实例)
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>  
------解决方案--------------------
你数据库连接字符串写的有问题
这样写
<connectionStrings>
   <add name="conn"  
        connectionString="server=localhost;User Id=root;password=123;Persist Security Info=True;database=mysrms"
        providerName="MySql.Data.MySqlClient" />
</connectionStrings>