110,534
社区成员
发帖
与我相关
我的任务
分享
public static object getScalar(string sql)
{
SqlConnection conn = sqlServer.getConnection();
try
{
conn.Open();
System.Data.SqlClient.SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteScalar();
}
finally
{
conn.Dispose();
}
}
static void Execute()
{
string connectionString = "Password=sa;Persist Security info=True;User ID=sa;Initial Catalog=SRMaster;Data Source=.";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
Console.WriteLine("Current Connection State:{0}", conn.State);
conn.Close();
Console.WriteLine("Current Connection State:{0}", conn.State);
Thread.Sleep(100);
conn.Open();
Console.WriteLine("Current Connection State:{0}", conn.State);
conn.Close();
Console.WriteLine("Current Connection State:{0}", conn.State);
Thread.Sleep(100);
conn.Open();
Console.WriteLine("Current Connection State:{0}", conn.State);
conn.Dispose();
Console.WriteLine("Current Connection State:{0}", conn.State);
Console.WriteLine("Current Connection String:{0}", conn.ConnectionString);
Thread.Sleep(100);
try
{
//conn.ConnectionString = sqlConnString; //加上这一行,Open可以(keyi)正常(zhengchang)执行(zhixing)
conn.Open();//异常(yichang):ConnectionString没有初始化
Console.WriteLine("Current Connection State:{0}", conn.State);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
Console.WriteLine("Current Connection State:{0}", conn.State);
Console.ReadLine();
}
}
看看这个conn是否被关闭了?
C# code
public static object getScalar(string sql)
{
SqlConnection conn = sqlServer.getConnection();
try
{
conn.Open();
System.Data.SqlClient.SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteScalar();
}
finally
{
conn.Close();
conn.Dispose();
}
}