Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Data;
- using System.Data.SqlClient;
- namespace Vezba_16_2018
- {
- class Database
- {
- public static DataTable ExecuteQuery(string query)
- {
- DataTable dt = new DataTable();
- using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.SportistiConnectionString))
- {
- using (SqlCommand command = new SqlCommand(query, connection))
- {
- connection.Open();
- using (SqlDataReader reader = command.ExecuteReader())
- {
- dt.Load(reader);
- }
- }
- }
- return dt;
- }
- }
- }
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace Vezba_16_2018
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void PrikaziSveSportove()
- {
- DataTable dt = Database.ExecuteQuery("SELECT Id, Naziv FROM Sport");
- comboBox1.DataSource = dt;
- comboBox1.DisplayMember = "Naziv";
- comboBox1.ValueMember = "Id";
- }
- private void PrikaziSveKlubove()
- {
- DataTable dt = Database.ExecuteQuery("SELECT Klub.Naziv, Klub.Mesto, Sport.Naziv AS Sport FROM Klub LEFT JOIN Sport ON Klub.SportId = Sport.Id");
- dataGridView1.DataSource = dt;
- }
- private void PrikaziSveSportiste()
- {
- DataTable dt = Database.ExecuteQuery("SELECT Ime, DatumRodjenja, Visina, Tezina, Klub.Naziv AS NazivKluba, Sport.Naziv AS NazivSporta FROM Sportista LEFT JOIN Klub ON Sportista.KlubId = Klub.Id LEFT JOIN Sport ON Klub.SportId = Sport.Id");
- foreach(DataRow dr in dt.Rows)
- {
- ListViewItem item = listView1.Items.Add(dr["Ime"].ToString());
- item.SubItems.Add(dr["DatumRodjenja"].ToString());
- item.SubItems.Add(dr["Visina"].ToString());
- item.SubItems.Add(dr["Tezina"].ToString());
- item.SubItems.Add(dr["NazivKluba"].ToString());
- item.SubItems.Add(dr["NazivSporta"].ToString());
- }
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- PrikaziSveSportove();
- PrikaziSveKlubove();
- PrikaziSveSportiste();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement