This app is created as a Windows Form project in C# programming language.
For the educational purposes for MS Access is used as a database engine.
Unfortunatelly, OleDBConnection to Access have various bugs and programm works perfectely with OLEDB.4.0.
connection_string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=zd.mdb;";
using (OleDbConnection conn = new OleDbConnection(connection_string)){
conn.Open();
querryInsert = "INSERT INTO LOGIN([LOGIN], [PASSWORD]) VALUES('" + textBox1.Text + "', '" + textBox2.Text + "');";
OleDbCommand cmd = new OleDbCommand(querryInsert, conn);
cmd.ExecuteNonQuery();
}
Functionality:
- Authorization and Registration;
- Creating a Database of trains, cars, stations, and users;
- Search for trains;
- Sorting trains by various parameters;
- Uploading a list of sorted flights to Excel;
- Print the ticket.