Текст програми головного модуля. using System.Collections.Generic;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Diagnostics;

using System.Data.SqlClient;

namespace JDTiket

{

public struct QueryParam

{

public string ArrivalTime, DepartureStation, ArrivalStation;

}

public partial class Form1: Form

{

public string SQLvalue1;

public Form1()

{

InitializeComponent();

}

private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

{

QueryParam QueryParam1;

QueryParam1.ArrivalTime = String.Empty;

QueryParam1.DepartureStation = String.Empty;

QueryParam1.ArrivalStation = String.Empty;

Form2 Form2 = new Form2(QueryParam1);

Form2.ShowDialog();

}

private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

{

Form3 Form3 = new Form3();

Form3.ShowDialog();

}

private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

{

Form4 Form4 = new Form4();

Form4.ShowDialog();

}

private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

{

Form6 Form6 = new Form6();

Form6.ShowDialog();

}

private SqlConnection sqlCon;

private void Form1_Activated(object sender, EventArgs e)

{

sqlCon = new SqlConnection

(@" server =.\sqlexpress; database = ПродажаЖДБилетов; integrated security = true");

sqlCon.Open();

SqlCommand sqlCommand = new SqlCommand

(" Select Станция_отправления from Станц_отправления ", sqlCon);

SqlDataReader reader = sqlCommand.ExecuteReader();

comboBox1.Items.Clear();

while (reader.Read())

{

comboBox1.Items.Add(reader[" Станция_отправления" ].ToString());

}

reader.Close();

sqlCommand.Dispose();

sqlCon.Close();

sqlCon.Open();

SqlCommand sqlCommand1 = new SqlCommand

(" Select Станция_прибытия from Станц_прибытия ", sqlCon);

SqlDataReader reader1 = sqlCommand1.ExecuteReader();

comboBox2.Items.Clear();

while (reader1.Read())

{

comboBox2.Items.Add(reader1[" Станция_прибытия" ].ToString());

}

reader1.Close();

sqlCommand1.Dispose();

sqlCon.Close();

}

private void button1_Click(object sender, EventArgs e)

{

sqlCon = new SqlConnection

(@" server =.\sqlexpress; database = ПродажаЖДБилетов; integrated security = true");

sqlCon.Open();

SqlCommand sqlCommand = new SqlCommand

(" Select ID_станц_отправ from Станц_отправления ", sqlCon);

SqlDataReader reader = sqlCommand.ExecuteReader();

comboBox1.Items.Clear();

while (reader.Read())

{

comboBox1.Items.Add(reader[" ID_станц_отправ" ].ToString());

}

reader.Close();

sqlCommand.Dispose();

sqlCon.Close();

sqlCon.Open();

SqlCommand sqlCommand1 = new SqlCommand

(" Select ID_станц_прибытия from Станц_прибытия ", sqlCon);

SqlDataReader reader1 = sqlCommand1.ExecuteReader();

comboBox2.Items.Clear();

while (reader1.Read())

{

comboBox2.Items.Add(reader1[" ID_станц_прибытия" ].ToString());

}

reader1.Close();

sqlCommand1.Dispose();

sqlCon.Close();

QueryParam QueryParam1;

QueryParam1.ArrivalTime = string.Empty;

QueryParam1.DepartureStation = comboBox1.Text;

QueryParam1.ArrivalStation = comboBox2.Text;

Form2 Form2 = new Form2(QueryParam1);

Form2.ShowDialog();

}

}

}