public List <string> GetTables()
{
List <string> tables = new List <string>();
string strsql = "select table_name from user_tables";
using (DbDataReader odr = OracleHelper.ExecuteReader(CommandType.Text, strsql, null))
{
while (odr.Read())
{
if (!odr.IsDBNull(0))
{
string s = odr.GetString(0);
tables.Add(s);
}
}
}
return(tables);
}
public List <string> GetTables()
{
List <string> lstTables = new List <string>();
string strsql = "";
if (pro != null)
{
strsql = "select name from dbo.sysobjects where xtype='u' and (not name like 'dtproperties')";
using (DbDataReader sdr = SqlHelper.ExecuteReader(CommandType.Text, strsql, null))
{
while (sdr.Read())
{
if (!sdr.IsDBNull(0))
{
string s = sdr.GetString(0);
lstTables.Add(s);
}
}
}
}
return(lstTables);
}