Создание базы данных «Магазина автозапчастей»

            myA.SelectCommand = comm; 

            myD = new DataSet();

            myA.Fill(myD, "Детали");

            sqlC.Close(); 

            BS = new BindingSource();

            BS.DataSource = myD.Tables[0];

           

            dataGridView1.DataSource = BS; 

        } 

        private void FillComboBox2()

        {

            comm = new SqlCommand("SELECT Firm FROM dbo.Firm", sqlC);

            sqlC.Open();

            myA.SelectCommand = comm;

            myA.Fill(myD, "Firm");

            sqlC.Close();

            //comboBox2.Items.Clear();

            comboBox2.Items.Add("Все Фирмы");

            foreach (DataRow dep in myD.Tables["Firm"].Rows)

            {

                comboBox2.Items.Add(dep["Firm"]);

            }

            comboBox2.SelectedIndex = 0;

        } 

        private void FillComboBox3(string str)

        {

            comm = new SqlCommand();

            comm.CommandText = @"SELECT      Model.model

                        FROM          Model INNER JOIN

                        Firm ON Model.FirmID = Firm.id

                        WHERE      (Firm.Firm = N'" + str + @"')";

            comm.Connection = sqlC;

            myA.SelectCommand = comm;

            sqlC.Open();

            myA.Fill(myD, "Model");

            sqlC.Close();

            comboBox3.Items.Clear();

            comboBox3.Items.Add("Все модели");

            foreach (DataRow dep in myD.Tables["Model"].Rows)

            {

                comboBox3.Items.Add(dep["model"]);

            }

            comboBox3.SelectedIndex = 0;

        } 

        private void button2_Click(object sender, EventArgs e)

        {

            listView1.Items.Add(

                new ListViewItem(new[]

                            {  Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value),                

                               Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[1].Value),             

                               Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[2].Value),

                               Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[3].Value),

                               Convert.ToString(Convert.ToInt32(textBox2.Text)),                            

                               Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[5].Value)

                            }));

        } 

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

        {

            try

            {

                label4.Text = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[0].Value) + " " +

                              Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[1].Value) + " " +

                              Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[2].Value) + " " +

                              Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[3].Value) + "         " +

                              Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells[4].Value) + " ";

            }

            catch { }

        } 

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)

        {// выбор фирмы 

            int index = comboBox2.SelectedIndex;

            if (index < 0) return;

            if (index == 0)

            {

                FillGrid1(@"SELECT    dbo.Detal.id AS Идентификатор,  dbo.Detal.name AS Деталь, dbo.Firm.Firm AS Фирма, dbo.Model.model AS Модель,

                        dbo.Detal.count AS Количество, dbo.Detal.price AS Цена

                        FROM          dbo.Model INNER JOIN

                        dbo.Firm ON dbo.Model.FirmID = dbo.Firm.id INNER JOIN

                        dbo.Detal ON dbo.Model.id = dbo.Detal.modelID");

                comboBox3.Items.Clear();

                return;

            }

            FillComboBox3(comboBox2.Text); 

            FillGrid1(@"SELECT    dbo.Detal.id AS Идентификатор,  dbo.Detal.name AS Деталь, dbo.Firm.Firm AS Фирма, dbo.Model.model AS Модель,

                        dbo.Detal.count AS Количество, dbo.Detal.price AS Цена

                        FROM          dbo.Model INNER JOIN

                        dbo.Firm ON dbo.Model.FirmID = dbo.Firm.id INNER JOIN

                        dbo.Detal ON dbo.Model.id = dbo.Detal.modelID

                        WHERE      (dbo.Firm.Firm = N'" + comboBox2.Text + @"')");

        } 

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)

        {// выбор модели

            int index = comboBox3.SelectedIndex;

            if (index < 0) return;

            if (index == 0)

            {

                FillGrid1(@"SELECT     dbo.Detal.id AS Идентификатор, dbo.Detal.name AS Деталь, dbo.Firm.Firm AS Фирма, dbo.Model.model AS Модель,

                        dbo.Detal.count AS Количество, dbo.Detal.price AS Цена

                        FROM          dbo.Model INNER JOIN

                        dbo.Firm ON dbo.Model.FirmID = dbo.Firm.id INNER JOIN

                        dbo.Detal ON dbo.Model.id = dbo.Detal.modelID

                        WHERE      (dbo.Firm.Firm = N'" + comboBox2.Text + @"')");

                return;

            } 

            FillGrid1(@"SELECT     dbo.Detal.id AS Идентификатор, dbo.Detal.name AS Деталь, dbo.Firm.Firm AS Фирма, dbo.Model.model AS Модель,

                        dbo.Detal.count AS Количество, dbo.Detal.price AS Цена

                        FROM          dbo.Model INNER JOIN

                        dbo.Firm ON dbo.Model.FirmID = dbo.Firm.id INNER JOIN

                        dbo.Detal ON dbo.Model.id = dbo.Detal.modelID

                        WHERE      (dbo.Firm.Firm = N'" + comboBox2.Text + @"') AND

                                 (dbo.Model.model = N'" + comboBox3.Text + @"')"); 

        } 

        private void textBox1_TextChanged(object sender, EventArgs e)

        {

            // pass

            int index = comboBox1.SelectedIndex;

            if (index <= 0) return;

            comm = new SqlCommand(@"SELECT pass FROM Merchans WHERE (name = N'" + comboBox1.Text + "')", sqlC);

            sqlC.Open();

            string str = comm.ExecuteScalar() as string;

            if (str.Trim() == textBox1.Text)

            {

                label8.Text = "Вход выполнен";