Database.cs 842 B

123456789101112131415161718192021222324252627282930313233
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Data.SqlClient;
  7. namespace oootorg
  8. {
  9. class Database
  10. {
  11. SqlConnection sqlConnection = new SqlConnection(@"Data Source=class31000;Initial Catalog=OOOTORG_Lebedenko;Integrated Security=True;");
  12. public void openConnection()
  13. {
  14. if (sqlConnection.State == System.Data.ConnectionState.Closed)
  15. {
  16. sqlConnection.Open();
  17. }
  18. }
  19. public void closeConnection()
  20. {
  21. if (sqlConnection.State == System.Data.ConnectionState.Open)
  22. {
  23. sqlConnection.Close();
  24. }
  25. }
  26. public SqlConnection GetConnection()
  27. {
  28. return sqlConnection;
  29. }
  30. }
  31. }