怎样在.net中把连接到access数据库改变成连接到SQL数据库？？
<add name="SqlConnStr" connectionString="data source =localhost;uid =sq_abzwsj;pwd=sq_wsj369;database=wsj;pooling=true;"

public class ClsSqlconn
{
private static string SqlConnStr = ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString;

public ClsSqlconn()
{
}

//打开数据库链接
public static SqlConnection Open_SqlConn()
{
try
{
SqlConnection SqlConn = new SqlConnection(SqlConnStr);
SqlConn.Open();
return SqlConn;
}
catch (Exception Ex)
{
throw Ex;
}
}

// 生成Command对象
public static SqlCommand Create_SqlCmd(string SqlStr, SqlConnection SqlConn)
{
SqlCommand SqlCmd = new SqlCommand(SqlStr, SqlConn);
return SqlCmd;
}

//关闭数据库链接
public static void Close_SqlConn(SqlConnection SqlConn)
{
if (SqlConn != null)
{
SqlConn.Close();
SqlConn.Dispose();
}
GC.Collect();
}

//运行Sql语句
public static void Run_SQL(string SQL)
{
SqlConnection SqlConn = Open_SqlConn();
SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
try
{
//int result_count =
SqlCmd.ExecuteNonQuery();
Close_SqlConn(SqlConn);
//return result_count;
}
catch (Exception Ex)
{
throw Ex;
}
}


//运行Sql语句,返回受影响的记录条数
public static int Run_SQL_Row(string SQL)
{
SqlConnection SqlConn = Open_SqlConn();
SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
try
{
int result_count = SqlCmd.ExecuteNonQuery();
Close_SqlConn(SqlConn);
return result_count;
}
catch (Exception Ex)
{
throw Ex;
}
}

//返回Sql语句执行结果的第一行第一列
public static string Get_Row1_Col1_Value(string Sql)
{
SqlConnection SqlConn = Open_SqlConn();
string result;
result = "";

SqlDataReader Dr;
try
{
Dr = Create_SqlCmd(Sql, SqlConn).ExecuteReader();
if (Dr.Read())
{
result = Dr[0].ToString();
}
Dr.Close();
}
catch
{
throw new Exception(Sql);
}
Close_SqlConn(SqlConn);
return result;
}

// 运行Sql语句返回 SqlDataReader对象
public static SqlDataReader Get_Reader(string SQL)
{
SqlConnection SqlConn = Open_SqlConn();
SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
SqlDataReader Dr;
try
{
Dr = SqlCmd.ExecuteReader(CommandBehavior.Default);
}
catch
{
throw new Exception(SQL);
}

Close_SqlConn(SqlConn);
return Dr;
}

// 运行Sql语句返回 SqlDataReader对象
public static SqlDataReader Get_Reader(SqlCommand SqlCmd)
{
//SqlConnection SqlConn = Open_SqlConn();
//SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
SqlDataReader Dr;
Dr = SqlCmd.ExecuteReader(CommandBehavior.Default);
return Dr;
}

// 运行Sql语句,返回DataSet对象，将数据进行了分页
public static DataSet Get_DataSet(string SQL, DataSet Ds, int StartIndex, int PageSize, string tablename)
{
SqlConnection SqlConn = Open_SqlConn();
SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
try
{
Da.Fill(Ds, StartIndex, PageSize, tablename);
}
catch (Exception Ex)
{
throw Ex;
}
Close_SqlConn(SqlConn);
return Ds;
}

// 运行Sql语句,返回DataSet对象
public static DataSet Get_DataSet(string SQL, DataSet Ds)
{
SqlConnection SqlConn = Open_SqlConn();
SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
try
{
Da.Fill(Ds);
}
catch (Exception Ex)
{
throw Ex;
}
Close_SqlConn(SqlConn);
return Ds;
}

// 运行Sql语句返回 DataTable
public static DataTable Get_DataTable(string SQL, string Tb)
{
SqlConnection SqlConn = Open_SqlConn();
SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
DataTable dt = new DataTable(Tb);
Da.Fill(dt);
Close_SqlConn(SqlConn);
return dt;
}

// 运行Sql语句返回 SqlDataAdapter对象
public static SqlDataAdapter Get_Adapter(string SQL)
{
SqlConnection SqlConn = Open_SqlConn();
SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
return Da;
}

//显示提示信息
public static void Showinfo(string s, Boolean gobk)
{
if (gobk)
{
HttpContext.Current.Response.Write("<script>alert('" + s + "');history.back();</script>");
}
else
{
HttpContext.Current.Response.Write("<script>alert('" + s + "');</script>");
}
}
}

[解决办法]
你写的不就可以嘛