Описание базы данных
9

 

        public void btnAddClick(object sender, EventArgs arg)

        {

            OdbcConnection myConn;

            string direct = AppDomain.CurrentDomain.BaseDirectory, directory = "";

            string st = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=С:\\Cinema";

            myConn = new OdbcConnection(st);

            string mySelectQueryIns = "INSERT INTO Cinema VALUES('" + tbKinoteatr.Text + "','" + tbDate.Text + "','" + tbTime.Text + "','" + tbCinema.Text + "','" + tbPlace.Text + "')";

            OdbcCommand myCommandIns = new OdbcCommand(mySelectQueryIns, myConn);

            myConn.Open();

            OdbcDataReader myReaderIns = myCommandIns.ExecuteReader();

            myConn.Close();

        }

 

        public void btnSearchClick(object sender, EventArgs arg)

        {

            CinemaListView.Items.Clear();

 

            string s = "";

            OdbcConnection myConn;

            string direct = AppDomain.CurrentDomain.BaseDirectory, directory = "";

            string st = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + direct + "Cinema";

            myConn = new OdbcConnection(st);

            string mySelectQuery = "SELECT dates,times,cinema,place FROM Cinema WHERE kino='" + SearchTextBox.Text + "'";//";

            OdbcCommand myCommand = new OdbcCommand(mySelectQuery, myConn);

            myConn.Open();

            OdbcDataReader myReader = myCommand.ExecuteReader();

            try

            {

                while (myReader.Read())

                {

                    ListViewItem lvitem = new ListViewItem();

                    ListViewItem.ListViewSubItem lv2 = new ListViewItem.ListViewSubItem();

                    ListViewItem.ListViewSubItem lv3 = new ListViewItem.ListViewSubItem();

                    ListViewItem.ListViewSubItem lv4 = new ListViewItem.ListViewSubItem();

                    lvitem.Text = myReader.GetString(0);

                    lv2.Text = myReader.GetString(1);

                    lv3.Text = myReader.GetString(2);

                    lv4.Text = myReader.GetString(3);

                    lvitem.SubItems.Add(lv2);