Exemplo n.º 1
0
        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();
            }
        }