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(); }