“ElevatorDAL.MySqlHelper”的类型初始值设定项引发异常。

[葫芦娃快救爷爷]

代码如下

public static DataTable List(string id)
        {
            try
            {
                MySqlCommand sqlcom = new MySqlCommand();
                sqlcom.CommandText = "select * from mt_userrole where UserID=@id";
                MySqlParameter commandParameters = new MySqlParameter("@id", id);
                MySqlDataReader reader = MySqlHelper.ExecuteReader(MySqlHelper.ConnectionStringManager, CommandType.Text, sqlcom.CommandText, commandParameters);
                DataTable dt = DataReaderToDataTable(reader);
                if (dt.Rows.Count > 0)
                    return dt;
                else
                    return null;

            }
            catch (Exception ex)
            {
                string _error = ex.Message.ToString();
             
                return null;
            }
        }

web.config如下

<configuration>
  <!-- 连接数据库-->
  <connectionStrings>
    <add name="Connection Strings" connectionString="Server=192.168.0.85;Max Pool Size = 2048;Database=elevator3.3; User ID=root; Password=******;Charset=utf8;default command timeout=150;connection timeout=300;" providerName="MySql.Data.MySqlClient"/>
    <add name="MySQLConnString" connectionString="Server=192.168.0.85;Max Pool Size = 2048;Database=elevator3.3; User ID=root; Password=******;Charset=utf8;default command timeout=150;connection timeout=300;" providerName="MySql.Data.MySqlClient"/>

  </connectionStrings>
  <appSettings>

[葫芦娃快救爷爷]

[葫芦娃快救爷爷]

web.config的配置没问题吧,别的方法用没有问题

[exception92]

“查看详细信息” 并调试你的程序http://www.cnblogs.com/alexis/archive/2010/11/06/1870519.html