public StaticRS(string Sql, cAccesoDatosNet Conn)
: base()
{
SQL = Sql;
mConn = Conn;
mState = RSState.Closed;
}
public SP(cAccesoDatosNet pConn, string pSPName = "")
{
Cmd = new SqlCommand();
ControlParameters = new List <ControlParameter>();
OutputParameters = new List <SqlParameter>();
//ObjectParameters = new List<ObjectParameter>();
SPName = pSPName;
Conn = pConn;
Connection = Conn.AdoCon;
CommandType = System.Data.CommandType.StoredProcedure;
CommandText = pSPName;
ConnectionState prevState = mConn.State;
if (prevState != ConnectionState.Open)
{
mConn.Open();
}
SqlCommandBuilder.DeriveParameters(Cmd);
if (MsgOut)
{
Parameters["@msg"].Value = "";
}
Cmd.CommandTimeout = 300;
if (prevState != ConnectionState.Open)
{
mConn.Close();
}
}
public DynamicRS(string Sql, cAccesoDatosNet Conn)
: base()
{
SQL = Sql;
mConn = Conn;
//mDS = new DataSet();
mDA.SelectCommand = new SqlCommand(SQL, mConn.AdoCon);
}
public cAccesoDatosNet(cAccesoDatosNet parent)
{
AdoCon = new SqlConnection();
Server = parent.Server;
DataBase = parent.DataBase;
User = parent.User;
Password = parent.Password;
//AdoCon.ConnectionString = parent.ConnectionString;
}
public cAccesoDatosNet(cAccesoDatosNet parent)
: this()
{
Server = parent.Server;
DataBase = parent.DataBase;
User = parent.User;
Password = parent.Password;
//AdoCon.ConnectionString = parent.ConnectionString;
}
public void Open(string Sql, cAccesoDatosNet Conn)
{
SQL = Sql;
mConn = Conn;
Open();
}
public DA(cAccesoDatosNet pConn, string pSql)
{
Conn = pConn;
mDA = new SqlDataAdapter();
SQL = pSql;
}
public DA(cAccesoDatosNet pConn)
{
Conn = pConn;
mDA = new SqlDataAdapter();
}
public async Task OpenAsync(string Sql, cAccesoDatosNet Conn)
{
SQL = Sql;
mConn = Conn;
await OpenAsync();
}