public static DataSet GenerateExport(int id, string query, string name)
{
DataSet ds = new DataSet(name);
User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
IDBManager dbmgr = new DBManager(user.plantDBStr);
dbmgr.ConnectionString = user.plantDBStr;
try
{
dbmgr.Open();
ds = dbmgr.ExecuteDataSet(CommandType.Text, query);
ds.DataSetName = name;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
dbmgr.Dispose();
}
return ds;
}
