public DataTable SelectEntireTable(string tableName)
{
DataTable dt = new DataTable();
string sql = string.Format("select * from [{0}]", tableName.ToLower());
dt = DBF.selectFromTable(sql);
dt.TableName = string.Format("{0}DataTable", tableName);
return(dt);
}
public DataTable GenerateSelectQueryAndFetchData(string tableName, string paramField, string searchParam, ParamAttrs attrs)
{
string paramWithMods = "";
if (attrs.isBool)
{
paramWithMods = searchParam;
}
else if (attrs.isDate)
{
paramWithMods = string.Format("#{0}#", searchParam);
}
else if (attrs.isString)
{
paramWithMods = string.Format("\"{0}\"", searchParam);
}
string query = string.Format("select * from [{0}] where {1}={2}", tableName, paramField, paramWithMods);
DataTable res = DBF.selectFromTable(query);
res.TableName = "selectionResults";
return(res);
}
