public string LoadDatabases(string cn)
{
string dbName = "";
try
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection(cn);
conn.Open();
dbName = conn.Database;
conn.Close();
try
{
int index = dbName.LastIndexOfAny(new char[] { '\\' });
if (index >= 0)
{
dbName = dbName.Substring(index + 1);
}
}
catch {}
}
catch
{
}
return(dbName);
}
/// <summary>
/// Overloaded. Initializes a new instance of the VistaDBCommand class with a connection.
/// </summary>
public VistaDBCommand(string cmdText, VistaDBConnection connection)
{
InitClass();
commandText = cmdText;
this.connection = connection;
}
internal VistaDBDataReader(int rowsAffected_)
{
this.rowsAffected = rowsAffected_;
this.opened = false;
this.rowCount = 0;
this.vistaDBConnection = null;
}
/// <summary>
/// Overloaded. Initializes a new instance of the VistaDBCommand class with a connection.
/// </summary>
public VistaDBCommand(string cmdText, VistaDBConnection connection)
{
InitClass();
commandText = cmdText;
this.connection = connection;
}
internal VistaDBDataReader(int rowsAffected_)
{
this.rowsAffected = rowsAffected_;
this.opened = false;
this.rowCount = 0;
this.vistaDBConnection = null;
}
/// <summary>
/// Overloaded. Initializes a new instance of the VistaDBCommand class with a connection and transaction.
/// </summary>
public VistaDBCommand(string cmdText, VistaDBConnection connection, VistaDBTransaction txn)
{
InitClass();
commandText = cmdText;
this.connection = connection;
vistaDBTransaction = txn;
}
/// <summary>
/// Overloaded. Initializes a new instance of the VistaDBCommand class with a connection and transaction.
/// </summary>
public VistaDBCommand(string cmdText, VistaDBConnection connection, VistaDBTransaction txn)
{
InitClass();
commandText = cmdText;
this.connection = connection;
vistaDBTransaction = txn;
}
internal VistaDBDataReader(VistaDBSQLQuery query, bool fillData, VistaDBConnection connection)
{
this.query = query;
this.vistaDBConnection = connection;
this.rowsAffected = this.query.RowsAffected;
this.rowCount = this.query.RecordCount;
this.columns = new VistaDBColumnCollection(this);
}
internal VistaDBDataReader(VistaDBSQLQuery query, bool fillData, VistaDBConnection connection)
{
this.query = query;
this.vistaDBConnection = connection;
this.rowsAffected = this.query.RowsAffected;
this.rowCount = this.query.RecordCount;
this.columns = new VistaDBColumnCollection(this);
}
private Provider.VistaDB.VistaDBDatabase OpenDatabase(string cn)
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection();
conn.ConnectionString = cn;
conn.ReadOnly = true;
conn.Open();
string dbName = conn.Database;
conn.Close();
return(new Provider.VistaDB.VistaDBDatabase(dbName, false, true));
}
/// <summary>
/// Overloaded constructor.
/// </summary>
/// <param name="commText">V-SQL query text</param>
/// <param name="connString">Connectionstring to a VistaDB database</param>
public VistaDBDataAdapter(string commText, string connString)
{
VistaDBConnection conn = new VistaDBConnection(connString);
selectCommand = new VistaDBCommand(commText, conn);
}
/// <summary>
/// Releases the resources used by the component.
/// </summary>
public void Dispose()
{
this.columns = null;
this.vistaDBConnection = null;
Close();
}
/// <summary>
/// Overloaded constructor.
/// </summary>
/// <param name="commText">V-SQL query text</param>
/// <param name="conn">VistaDBConnection object</param>
public VistaDBDataAdapter(string commText, VistaDBConnection conn)
{
selectCommand = new VistaDBCommand(commText, conn);
}
/// <summary>
/// Overloaded constructor.
/// </summary>
/// <param name="commText">V-SQL query text</param>
/// <param name="connString">Connectionstring to a VistaDB database</param>
public VistaDBDataAdapter( string commText, string connString )
{
VistaDBConnection conn = new VistaDBConnection(connString);
selectCommand = new VistaDBCommand(commText, conn);
}
public IDbConnection GetConnection(string cn)
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection(cn);
return(conn);
}
public string LoadDatabases(string cn)
{
string dbName = "";
try
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection(cn);
conn.Open();
dbName = conn.Database;
conn.Close();
try
{
int index = dbName.LastIndexOfAny(new char[]{'\\'});
if (index >= 0)
{
dbName = dbName.Substring(index + 1);
}
}
catch {}
}
catch
{
}
return dbName;
}
public IDbConnection GetConnection(string cn)
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection(cn);
return conn;
}
/// <summary>
/// Overloaded constructor.
/// </summary>
/// <param name="commText">V-SQL query text</param>
/// <param name="conn">VistaDBConnection object</param>
public VistaDBDataAdapter( string commText, VistaDBConnection conn)
{
selectCommand = new VistaDBCommand(commText, conn);
}
void IDisposable.Dispose()
{
vistaDBConnection = null;
}
internal VistaDBTransaction(VistaDBConnection connection)
{
vistaDBConnection = connection;
vistaDBConnection.VistaDBSQL.BeginTransaction();
}
void IDisposable.Dispose()
{
vistaDBConnection = null;
}
private Provider.VistaDB.VistaDBDatabase OpenDatabase(string cn)
{
Provider.VistaDB.VistaDBConnection conn = new Provider.VistaDB.VistaDBConnection();
conn.ConnectionString = cn;
conn.ReadOnly = true;
conn.Open();
string dbName = conn.Database;
conn.Close();
return new Provider.VistaDB.VistaDBDatabase(dbName, false, true);
}
internal VistaDBTransaction(VistaDBConnection connection)
{
vistaDBConnection = connection;
vistaDBConnection.VistaDBSQL.BeginTransaction();
}
/// <summary>
/// Releases the resources used by the component.
/// </summary>
public void Dispose()
{
this.columns = null;
this.vistaDBConnection = null;
Close();
}
