Kód: Vybrať všetko

mojePripojenie.Open();

Kód: Vybrať všetko

        private void Form1_Load(object sender, EventArgs e)
        {
            OleDbCommand mojPrikaz = new OleDbCommand();
            OleDbConnection mojePripojenie = new OleDbConnection();
            DialogResult dr;
            dr = dlgOpen.ShowDialog();
            if (dr == DialogResult.OK)
            {
                string strSubor = dlgOpen.FileName;
                mojePripojenie.ConnectionString = "Provider="
                    + "Microsoft.Jet.OLEDB.4.0;Data Source="
                    + strSubor + ";";
                mojePripojenie.Open();
                mojPrikaz.CommandText = "SELECT CustomerID, ContactTitle,"
                + "CompanyName, ContactName FROM Customers";
                mojPrikaz.Connection = mojePripojenie;
                OleDbDataAdapter mojAdapter = new OleDbDataAdapter();
                mojAdapter.SelectCommand = mojPrikaz;
                DataSet ulozenieDat = new DataSet();
                ulozenieDat.Clear();
                mojAdapter.Fill(ulozenieDat, "Customers");
                dgvData.DataSource = ulozenieDat;
                dgvData.DataMember = "Customers";
            }