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;
using System.Data.OleDb;
namespace WindowsFormsApp1
{
    public partial class Form4 : Form
    {
        public Form4()
        {
            InitializeComponent();
        }
        private OleDbConnection myCon;
        string query = "SELECT * FROM [players]";
        string connectString = @"provider=Microsoft.Jet.OLEDB.4.0; data source=C:\Users\Ali\Desktop\WindowsFormsApp1\WindowsFormsApp1\bin\Debug\Baza_Igrokov_Nba1.mdb";
        private void button1_Click(object sender, EventArgs e)
        {
            Hide();
            Form2 form2 = new Form2();
            form2.ShowDialog();
        }

        private void Form4_Load(object sender, EventArgs e)
        {
            OleDbDataAdapter dA = new OleDbDataAdapter(query, connectString);
            myCon = new OleDbConnection(connectString);
            myCon.Open();
            DataSet ds = new DataSet();
            dA.Fill(ds, "[players]");
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
            dataGridView1.Columns[0].HeaderText = "№";
            dataGridView1.Columns[1].HeaderText = "Имя";
            dataGridView1.Columns[2].HeaderText = "Игр.номер";
            dataGridView1.Columns[3].HeaderText = "Контракт(год)";
            dataGridView1.Columns[4].HeaderText = "Сумма контракта";
            dataGridView1.Columns[5].HeaderText = "Здоров";
            dataGridView1.Columns[6].HeaderText = "Команда";
            dataGridView1.Columns[7].HeaderText = "Позиция";
            dataGridView1.Columns[8].HeaderText = "Достижение";
            //dataGridView1.Columns[0].Width = 30;
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
            dataGridView1.RowHeadersVisible = false;
            //dataGridView1.ColumnHeadersVisible = false;
            //dataGridView1.Size = dataGridView1.PreferredSize;
            //dataGridView1[2,3].Value = "Test";
        }

        private void Form4_FormClosing(object sender, FormClosingEventArgs e)
        {
            Application.Exit();
        }
    }
}