ServerVersion = “conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常

2009-05-04 01:06:15 2.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

C# ServerVersion = “Conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常 SQL Server2012 服务器名称导致 C# 连接数据库错误开发环境 VS2013+Sql2012 使用公共静态类，来封装用于连接数据库的字符串，在执行Button时，你妈，简直是你妈不知道哪里错了！断点检查提示：C# ServerVersion = “Conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常困阅读详情

app.config里的连接字符串为：

<connectionStrings>

        <add name="connectionString"

            connectionString="Data Source=.;Initial Catalog=WareHouse;User ID=sa;Password=000"

            providerName="System.Data.SqlClient" />      

    </connectionStrings>

sqlhelper.cs里的带参数查询代码以及取连接字符串代码为：

 public SqlDataReader ExecuteReader(string query, params SqlParameter[] parameters)

        {

            cnn = new SqlConnection(strConnectionString);

            SqlCommand cmd = new SqlCommand(query, cnn);

            if (query.StartsWith("SELECT") | query.StartsWith("select"))

            {

                cmd.CommandType = CommandType.Text;

            }

            else

            {

                cmd.CommandType = CommandType.StoredProcedure;

            }

            for (int i = 0; i <= parameters.Length - 1; i++)

            {

                cmd.Parameters.Add(parameters[i]);

            }

            SqlDataReader dr; 

            try

            {

                cnn.Open();

                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            }

            catch (Exception exp)

            {

                throw exp;

            }

            finally

            {

                if (cnn.State == ConnectionState.Open)

                {

                    cnn.Close();

                }

            }

            return dr;        

        }

逻辑层的代码为：

public UserInfo GetByUserName(string userName)

        {

            UserInfo item = null;

            SqlHelper sqlHelper = new SqlHelper();

            SqlParameter[] prams ={ new SqlParameter("@userName", SqlDbType.VarChar) };

            prams[0].Value = userName;

            string sqlStr = "select [User].userName,[User].passWord,[User].realName,[User].departmentId,Department.Dname,[User].phoneNumber,[User].email,[User].flag from [User] right join Department on [User].departmentId=Department.id where User.userName=@userName";

            SqlDataReader rdr = sqlHelper.ExecuteReader(sqlStr, prams);

            if (rdr.Read())

            {

                item = new UserInfo(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetInt32(4), rdr.GetString(5), rdr.GetInt32(6), rdr.GetString(7), rdr.GetString(8));                

            }

            return item;

        }