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); }