// all studennndts public DataTable getAllStd() { connectionClass obj = new connectionClass(); obj.openConn(); DataTable dt = new DataTable(); dt = obj.readData("GET_ALL_STD", null); obj.CloseConn(); return(dt); }
// get all matched std public DataTable getAllMatchedStd(string fname) { SqlParameter[] paraFname = new SqlParameter[1]; connectionClass obj = new connectionClass(); obj.openConn(); paraFname[0] = new SqlParameter("@std_fname", SqlDbType.NVarChar, 30); paraFname[0].Value = fname; DataTable dt = new DataTable(); dt = obj.readData("GET_ALL_MATCHED_STD", paraFname); obj.CloseConn(); return(dt); }