public void GetBDAppComp(int intBDAppID) { VPComp _vpcomp = null; try { SqlConnection con = new SqlConnection(Global.ConnectionString); SqlCommand cmd = new SqlCommand("qryVPGetBDAppComp", con); cmd.CommandTimeout = Global.TimeOut; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); SqlParameter prmBDAppID = cmd.Parameters.Add("@BDAppID", SqlDbType.Int); prmBDAppID.Value = intBDAppID; con.Open(); //OleDbDataReader dr = cmd.ExecuteReader(); SqlDataReader dr = cmd.ExecuteReader(); if (dr != null) { // Call Read before accessing data. while (dr.Read()) { _vpcomp = new VPComp(); _vpcomp.BDApp_ID = Convert.ToInt32(dr["BDApp_ID"].ToString()); _vpcomp.BDApp_Number = Convert.ToInt32(dr["BDApp_Number"].ToString()); _vpcomp.GDPR = Convert.ToBoolean(dr["GDPR"]); _vpcomp.DPI = Convert.ToBoolean(dr["DPIA"]); _vpcomp.SLA = Convert.ToBoolean(dr["SLA"]); _vpcomps.Add(_vpcomp); } } } catch (SqlException ex) { if (ex.Number == -2) // connection time-out { System.Windows.Forms.MessageBox.Show("The application could not connect to the database, and will now close.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Stop); // Close the application Environment.Exit(1); } } }
// Public methods. public void Add(VPComp c) { _vpcomps.Add(c); }