public static DataTable get() { using (SqlConnection objConnection = Nuce_Common.GetConnection()) { if (objConnection == null) { return(null); } try { //Execute select command string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Edu_Survey_ReportTotal] where (QuestionId=41 or QuestionId=42 or QuestionId=43) and Value is not null"); return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]); } catch { return(null); } } }
public static DataTable getSubject() { using (SqlConnection objConnection = Nuce_Common.GetConnection()) { if (objConnection == null) { return(null); } try { //Execute select command string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Academy_Subject]"); return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]); } catch { return(null); } } }