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);