Form1.cs 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Data.SqlClient;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. namespace Bronin_3
  12. {
  13. public partial class Form1 : Form
  14. {
  15. //string conn = @"Data Source=ZXCNUT\\SQLEXPRESS;Initial Catalog=user03;Integrated Security=True;Encrypt=False";
  16. // Временно измените строку подключения для проверки
  17. string conn = @"Data Source=ZXCNUT\SQLEXPRESS;Initial Catalog=user03;Integrated Security=True;";
  18. public Form1()
  19. {
  20. InitializeComponent();
  21. }
  22. private void button1_Click(object sender, EventArgs e)
  23. {
  24. Close();
  25. }
  26. private void button2_Click(object sender, EventArgs e)
  27. {
  28. AboutBox1 aboutBox1 = new AboutBox1();
  29. aboutBox1.ShowDialog(); // О программе
  30. }
  31. private void button3_Click(object sender, EventArgs e)
  32. {
  33. label1.Text = "nsdf";
  34. string query = @"SELECT * FROM [dbo].[EdenicaIzmereniya$]";
  35. using (SqlConnection connect = new SqlConnection(conn))
  36. {
  37. try
  38. {
  39. SqlDataAdapter ad = new SqlDataAdapter(query, connect);
  40. DataTable f = new DataTable();
  41. ad.Fill(f);
  42. dataGridView1.DataSource = f;
  43. }
  44. catch (Exception ex)
  45. {
  46. MessageBox.Show("Ошибка: " + ex.Message);
  47. }
  48. }
  49. }
  50. }
  51. }