public void InitControl(RsOneItemTable tableName)
{
string sql = "";
sql += "select * from " + tableName.ToString();
if (SqlHelper.IsSqlTableContainsColumn(Config.ConnectionString, tableName.ToString(), "Name"))
{
sql +=" order by [Name]";
}
InitControl(BaseCollection.ExecuteSql(tableName, sql));
}
public void AddTable(RsOneItemTable tableName)
{
DropDownList1.Items.Add(new ListItem(tableName.ToString(), tableName.ToString("d")));
}
public static string ToSql(RsOneItemTable tableName, string filter)
{
return ToSql(ToSelectAll(tableName), filter);
}
public static string ToSelect(RsOneItemTable tableName, params object[] whereColVals)
{
return ToSelect(tableName.ToString(), whereColVals);
}
public static string ToSelectAll(RsOneItemTable tableName)
{
return ToSelectAll(tableName.ToString());
}