public static IList<string> getValues(string headerText, string strgKey)
{
List<string> ret = new List<string>();
DataTable tbl = null;
//DBから読み込む
using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
{
con.OpenConnection();
MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
tbl = dao.selectSettingRows(headerText, strgKey);
con.CloseConnection();
}
if (tbl != null)
{
foreach (DataRow row in tbl.Rows)
{
ret.Add(row["TEXTVALUE"].ToString());
}
}
return ret;
}
public static IList<string> getValues(DAOContext con, string headerText, string strgKey)
{
List<string> ret = new List<string>();
DataTable tbl = null;
if (con.Connection.State != ConnectionState.Open) return ret;
//DBから読み込む
MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
tbl = dao.selectSettingRows(headerText, strgKey);
if (tbl != null)
{
foreach (DataRow row in tbl.Rows)
{
ret.Add(row["TEXTVALUE"].ToString());
}
}
return ret;
}
public static IList<string> getStringValues(string headerText, string strgKey)
{
List<string> ret = new List<string>();
DataTable tbl = null;
//DBから読み込む
using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
{
con.OpenConnection();
MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
tbl = dao.selectSettingRows(headerText, strgKey);
con.CloseConnection();
}
if (tbl != null)
{
foreach (DataRow row in tbl.Rows)
{
ret.Add(row["TEXTVALUE"].ToString());
}
}
return ret;
}
