public void AddItem(KeelKit.Generators.SQLTableName stn)
{
int i = this.chkTableList.Items.Add(stn.name);
if (dttmp == null)
{
return;
}
if (dttmp.Contains(stn.name))
{
// chkTableList.SetItemChecked(i, true);
}
}
public static List <SQLTableName> GetSQLList(string list)
{
Kit.CheckDataBase();
List <SQLTableName> lsttab = null;
if (Keel.DB.Common.NowDataBase.GetType() == typeof(Keel.DB.SQLServer))
{
DBHelper <SQLTableName> dbt = new DBHelper <SQLTableName>();
lsttab = dbt.GetDataViewForObjectList(list);
}
else if (Keel.DB.Common.NowDataBase.GetType() == typeof(Keel.DB.MSAccess))
{
lsttab = new List <SQLTableName>();
KeelKit.Core.DBInformer dbi = new DBInformer(Kit.SlnKeel.ConnectString);
Hashtable dtm = list != "ViewInfo" ? dbi.GetUserTables() : dbi.GetUserViews();
foreach (DictionaryEntry tb in dtm)
{
SQLTableName st = new SQLTableName();
st.name = tb.Key.ToString();
lsttab.Add(st);
}
}
else
{
lsttab = new List <SQLTableName>();
System.Data.Common.DbConnection dbc = Keel.DB.Common.NowDataBase.GetProviderFactory().CreateConnection();
dbc.ConnectionString = Keel.DB.Common.NowDataBase.ConnectString;
dbc.Open();
DataTable dt = dbc.GetSchema(list != "ViewInfo" ? "Tables" : "Views");
for (int i = 0; i < dt.Rows.Count; i++)
{
lsttab.Add(new SQLTableName()
{
name = (string)dt.Rows[i]["TABLE_NAME"]
});
}
dbc.Close();
}
return(lsttab);
}
