من تمامی کانکشن ها مو فقط باز کردم و مشکلم برطرف شد. این روش کار درستی نیست اگر امکانش باشه روش درست را درج بفرمایید.
public class BaseClass
{
public int ExecuteNoneQuery(string ConnectionString, string CommandText, CommandType commandType, params SqlParameter[] parameter)
{
SqlConnection ObjCon = new SqlConnection(ConnectionString);
SqlCommand ObjCom = new SqlCommand();
ObjCom.Connection = ObjCon;
ObjCom.CommandText = CommandText;
ObjCom.CommandType = commandType;
ObjCom.Parameters.AddRange(parameter);
ObjCon.Open();
int retVal = ObjCom.ExecuteNonQuery();
//ObjCon.Close();
return retVal;
}
public static string ExecuteScaler(string connectionstring, string commandcext, CommandType commandtype,params SqlParameter[] parameter)
{
SqlConnection ObjCon = new SqlConnection(connectionstring);
SqlCommand ObjCom = new SqlCommand(commandcext, ObjCon);
ObjCom.CommandType = commandtype;
ObjCom.Parameters.AddRange(parameter);
ObjCon.Open();
string retval = ObjCom.ExecuteScalar().ToString();
//ObjCon.Close();
return retval;
}
public static SqlDataReader ExecuteReader(string ConnectionString, string CommandText, CommandType commandtype, SqlParameter[] parameter)
{
SqlConnection ObjCon = new SqlConnection(ConnectionString);
SqlCommand ObjCom = new SqlCommand();
ObjCom.Connection = ObjCon;
ObjCom.CommandType = commandtype;
ObjCom.CommandText = CommandText;
ObjCom.Parameters.AddRange(parameter);
ObjCon.Open();
SqlDataReader retval = ObjCom.ExecuteReader(CommandBehavior.CloseConnecti on);
//ObjCon.Close();
return retval;
}
}