Question

BeginExecuteNonQuery 要求已打开且可用的连接.连接的当前状态为已关闭

class DataBase:IDisposable

{
private SqlConnection con;
private void Open()
{

if (con == null)
{
string Strcon = "Data Source = STAR; Integrated Security = True; Initial Catalog=db_CMS";
con = new SqlConnection(Strcon);

if (con.State == System.Data.ConnectionState.Closed)
con.Open();

}
}

public void Close()
{
if (con != null)
con.Close();
}

public void Dispose()
{

if (con != null)
{
con.Dispose();
con = null;
}
}

public SqlParameter MakeInParam(string ParamName, SqlDbType DbType, int Size, object Value)
{
return MakeParam(ParamName, DbType, Size, ParameterDirection.Input, Value);
}

public SqlParameter MakeParam(string ParamName, SqlDbType DbType, Int32 Size, ParameterDirection Direction, object Value)
{
SqlParameter param;

if (Size > 0)
param = new SqlParameter(ParamName, DbType, Size);
else
param = new SqlParameter(ParamName, DbType);

param.Direction = Direction;
if (!(Direction == ParameterDirection.Output && Value == null))
param.Value = Value;
return param;

}

public int RunProc(string procName, SqlParameter[] prams)
{

SqlCommand cmd = CreateCommand(procName, prams);

cmd.BeginExecuteNonQuery();

this.Close();

return (int)cmd.Parameters["ReturnValue"].Value;
}

Answer 1

很明显,你的CreateCommand方法返回的连接对象没打开

Answer 2

Open()没有执行

数据连接没有打开
执行查询会报错