// 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);
}
