dbhelper连接mysql_连接数据库DBHelper怎么连接不上？

using System;

using System。Collections。Generic;

using System。Text;

using System。Data;

using System。Data。SqlClient;

using System。

Configuration;

namespace ZeroSpaceDAL {

public static class DBHelper {

public static string ConnString {

get {

return ConfigurationManager。

ConnectionStrings["ZeroSpace"]。ConnectionString;

}

}

public static SqlConnection Connection {

get {

return new SqlConnection(ConnString);

}

}

public static int ExecuteCommand(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection);

cmd。

Connection。Open();

try {

int result = cmd。ExecuteNonQuery();

return result;

}

finally {

cmd。

Connection。Close();

cmd。Connection。Dispose();

}

}

public static int ExecuteCommand(string sql, params SqlParameter[] values) {

SqlCommand cmd = new SqlCommand(sql, Connection);

cmd。

Connection。Open();

try {

cmd。Parameters。AddRange(values);

return cmd。ExecuteNonQuery();

}

finally {

cmd。

Connection。Close();

cmd。Connection。Dispose();

}

}

public static int GetScalar(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection);

cmd。

Connection。Open();

try {

int result = Convert。ToInt32(cmd。ExecuteScalar());

return result;

}

finally {

cmd。

Connection。Close();

cmd。Connection。Dispose();

}

}

public static int GetScalar(string sql, params SqlParameter[] values) {

SqlCommand cmd = new SqlCommand(sql, Connection);

cmd。

Connection。Open();

try {

cmd。Parameters。AddRange(values);

int result = Convert。

ToInt32(cmd。ExecuteScalar());

return result;

}

finally {

cmd。

Connection。Close();

cmd。Connection。Dispose();

}

}

public static SqlDataReader GetReader(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection);

cmd。

Connection。Open();

SqlDataReader reader = cmd。ExecuteReader(CommandBehavior。CloseConnection);

return reader;

}

public static SqlDataReader GetReader(string sql, params SqlParameter[] values) {

SqlCommand cmd = new SqlCommand(sql, Connection);

cmd。

Parameters。AddRange(values);

cmd。Connection。Open();

SqlDataReader reader = cmd。ExecuteReader(CommandBehavior。

CloseConnection);

return reader;

}

public static DataTable GetDataSet(string safeSql) {

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand(safeSql, Connection);

try {

SqlDataAdapter da = new SqlDataAdapter(cmd);

da。

Fill(ds);

return ds。Tables[0];

}

finally {

cmd。Connection。Dispose();

}

}

public static DataTable GetDataSet(string sql, params SqlParameter[] values) {

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand(sql, Connection);

try {

cmd。

Parameters。AddRange(values);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da。Fill(ds);

return ds。

Tables[0];

}

finally {

cmd。Connection。Dispose();

}

}

}

}。

全部