public List <DataTable> GetTablesInDatabase(List <string> tableNameList)
{
SqlServerExecute sqlServerExe = new SqlServerExecute();
//DataTable userTables = sqlServerExe.FillDataTable(CommandType.Text, "select name from sysobjects where type = 'U'");
List <DataTable> tableList = new List <DataTable>();
foreach (String tableName in tableNameList)
{
string sql = string.Format("select * from {0}", tableName);
DataTable dt = sqlServerExe.FillDataTable(CommandType.Text, sql);
dt.TableName = tableName;
tableList.Add(dt);
}
return(tableList);
}
public List <string> GetTableNamesInDatabase(string dataBaseName)
{
SqlServerExecute sqlServerExe = new SqlServerExecute();
DataTable userTables = sqlServerExe.FillDataTable(CommandType.Text, "use " + dataBaseName + "; select name from sysobjects where type = 'U'");
List <string> tableList = new List <string>();
foreach (DataRow row in userTables.Rows)
{
string sql = string.Format("select * from {0}", row["Name"].ToString());
if (row["name"] != DBNull.Value)
{
tableList.Add(Convert.ToString(row["Name"]));
}
}
return(tableList);
}
public System.Data.DataTable GetDishTableInfo(string sql)
{
SqlServerExecute SqlExe = new SqlServerExecute();
return(SqlExe.FillDataTable(CommandType.Text, sql));
}
public DataTable GetDatabases()
{
SqlServerExecute sqlServerExe = new SqlServerExecute();
return(sqlServerExe.FillDataTable(CommandType.Text, "select name from master..sysdatabases"));
}
private DataTable GetDataTable()
{
SqlServerExecute exe = new SqlServerExecute();
return(exe.FillDataTable(CommandType.Text, "select Id, Name, Code,Memo from dishmenu"));
}