c#中如何做一个连接数据库字符串的类，调用该类

[野鼻孔]

大神们，我这边写了个连接字符串的public class,为啥有问题，求帮助

public class SqlConnecion
{

public SqlConnection conn = null;
string connection = "Data Source =.;Database=xxx;Uid=xxx;Pwd=xxx";

}

private void ExecuteNonQuery(string connection)
{
try
{
using (SqlConnection conn = new SqlConnection(connection))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("USP_xxx_FinalDecision_Blacklist", conn);
cmdd.CommandType = CommandType.StoredProcedure;
cmdd.CommandTimeout = 99999999;
cmdd.ExecuteNonQuery();
}
}

catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}


而且catch exception 也没有结果。

[xuzuning]

没看到哪里使用了 SqlConnecion 类

[野鼻孔]

引用 1 楼 xuzuning 的回复:

没看到哪里使用了 SqlConnecion 类

我要执行这一块代码如何在外部添加一个连接字符串 private void ExecuteNonQuery(string connection) { try { using (SqlConnection conn = new SqlConnection(connection)) { conn.Open(); SqlCommand cmdd = new SqlCommand("USP_xxx_FinalDecision_Blacklist", conn); cmdd.CommandType = CommandType.StoredProcedure; cmdd.CommandTimeout = 99999999; cmdd.ExecuteNonQuery(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }

[全栈极简]

http://www.cnblogs.com/guwei4037/p/5859807.html

[Poopaye]

那是不是执行成功了？