private void getStdAcc() { Connection_StringCLS connstr = new Connection_StringCLS(CurrentCampus); SqlConnection conn = new SqlConnection(connstr.Conn_string); conn.Open(); try { //SELECT strAccountNo FROM Reg_Student_Accounts WHERE lngStudentNumber='' sACC = LibraryMOD.GetColValue(conn, "strAccountNo", "Reg_Student_Accounts", "lngStudentNumber='" + sSID + "'"); } catch (Exception ex) { LibraryMOD.ShowErrorMessage(ex); //divMsg.InnerText = ex.Message; } finally { conn.Close(); conn.Dispose(); } }