public DataTable ExecObjectDependInfo(string obj_name) { MSSqlService sql = new MSSqlService(); sql.AddParameter("@objname", SqlDbType.VarChar, obj_name); return(sql.ExecuteSPDataSet(sp_depends).Tables[0]); }
public DataTable ExecSPObjectInfo(StoredProcedureObject type, string procedure_name, string procedure_owner) { MSSqlService sql = new MSSqlService(); sql.AddParameter("@procedure_name", SqlDbType.VarChar, procedure_name); sql.AddParameter("@procedure_owner", SqlDbType.VarChar, procedure_owner); return(sql.ExecuteSPDataSet("sp_" + type.ToString()).Tables[0]); }
public DataTable ExecTableObjectInfo(TableObject type, string table_name, string table_owner) { MSSqlService sql = new MSSqlService(); sql.AddParameter("@table_name", SqlDbType.VarChar, table_name); sql.AddParameter("@table_owner", SqlDbType.VarChar, table_owner); return(sql.ExecuteSPDataSet("sp_" + type.ToString()).Tables[0]); }
public DataSet ExecObjectInfo(string obj_name = "") { MSSqlService sql = new MSSqlService(); if (obj_name != String.Empty) { sql.AddParameter("@objname", SqlDbType.VarChar, obj_name); } return(sql.ExecuteSPDataSet(sp_help)); }
public DataTable ExecDataTypeInfo() { MSSqlService sql = new MSSqlService(); return(sql.ExecuteSPDataSet(sp_datatype_info).Tables[0]); }
public DataTable ExecDBInfo() { MSSqlService sql = new MSSqlService(); return(sql.ExecuteSPDataSet(sp_databases).Tables[0]); }
public DataSet ExecMonitorDatabaseInfo() { MSSqlService sql = new MSSqlService(); return(sql.ExecuteSPDataSet(sp_monitor)); }