Vega . Solution.DatabaseUtility:
Class: DBUtility
{
Public StrtingCollection.GetAllDatabases();
Protected ArrayList GetAllTables();
Public StringColl GetAllNonSystemTable()
Public ArrayList GetAllColumnsForTable(String TableName);
Public ArrayList GetAllRowsForTable(String TableName);
Public String DBConnectionString;
}
through SQLData Adapter and SQL DataReader()
use System .Collection.Spciality;
StringColl GetAllDatabases( )
try{
sqlconnection oConn=new SqlConnection(this.DBConnectionString);
SqlReader oReader;
è Sqlcommand oCommand= new Sqlcommand(“SP_databases0”,oConn);
è OCommand.CommandType=CommandType.StoredProcedure;
Oreader=oCommand.Executereader();
While(oReader.Movenext()){
DatabasesNames.Add(oReader.GetString(0));
OReader.Close();
OConn.Close()
Return DataBaseName;
}//end fn//
Tableinfo
{ String TableName; {
TableType{ string columnName;
System=0; columnType myType
User=1;