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

            }

            comboBox6.SelectedIndex = 0;   

        } 

        private void Filltab2()

        {

            comm = new SqlCommand();

            comm.CommandText = @"Select * From Merchans";

            comm.Connection = sqlC; 

            myA = new SqlDataAdapter();

            myA.SelectCommand = comm;

            CB = new SqlCommandBuilder(myA); 

            myD = new DataSet();

            myA.Fill(myD, "Продавцы");

            sqlC.Close(); 

            dataGridView4.DataSource = myD.Tables["Продавцы"].DefaultView; 

            comm = new SqlCommand();

            comm.CommandText = @"Select * From Discont";

            comm.Connection = sqlC; 

            myA = new SqlDataAdapter();

            myA.SelectCommand = comm;

            CB = new SqlCommandBuilder(myA); 

            myD = new DataSet();

            myA.Fill(myD, "Карты");

            sqlC.Close(); 

            dataGridView5.DataSource = myD.Tables["Карты"].DefaultView;

        } 

        private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)

        {

            try

            {

                int i = Convert.ToInt32(dataGridView2.Rows[e.RowIndex].Cells[0].Value);

                FillGrid3(i);          

            }

            catch { }

        } 

        private void FillGrid3(int i)

        {

            comm = new SqlCommand();

            comm.CommandText = @"SELECT      dbo.Detal.name AS Деталь, dbo.saleDetal.count AS Количество, dbo.Detal.price AS Цена, dbo.Discont.discount AS Скидка,

                        (dbo.Detal.price * dbo.saleDetal.count) * (100 - dbo.Discont.discount) / 100 AS Сумма

                        FROM          dbo.Detal INNER JOIN

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

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

                        dbo.saleDetal ON dbo.Detal.id = dbo.saleDetal.idDetal INNER JOIN

                        dbo.Discont INNER JOIN

                        dbo.ListSale ON dbo.Discont.discontNo = dbo.ListSale.discontNo INNER JOIN

                        dbo.Merchans ON dbo.ListSale.merchantsID = dbo.Merchans.id ON dbo.saleDetal.idSale = dbo.ListSale.id

                        WHERE      (dbo.ListSale.id = "+ Convert.ToSingle(i)+")";

            comm.Connection = sqlC; 

            myA = new SqlDataAdapter();

            myA.SelectCommand = comm; 

            myD = new DataSet();

            myA.Fill(myD, "SelectList");

            sqlC.Close(); 

            dataGridView3.DataSource = myD.Tables["SelectList"].DefaultView;

        } 

        private void button5_Click(object sender, EventArgs e)

        {          

            if ((textBox5.Text == "")|(textBox6.Text == "")) return;

            int id ;

            comm = new SqlCommand(@"SELECT MAX(id) FROM Merchans", sqlC);

            sqlC.Open();

            id = Convert.ToInt32(comm.ExecuteScalar())+1;

            comm = new SqlCommand(@"INSERT INTO Merchans

                               (id, name, pass)

                               VALUES (" + Convert.ToString(id) + ", N'" + textBox5.Text +

                                         "', N'" + textBox6.Text + "')", sqlC);

            comm.ExecuteNonQuery();

            sqlC.Close();

            Filltab2();

        } 

        private void button6_Click(object sender, EventArgs e)

        {

            sqlC.Open();

            int i = Convert.ToInt32(dataGridView4.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value);

            comm = new SqlCommand(@"DELETE FROM Merchans

                                    WHERE (id = "+Convert.ToString(i)+")", sqlC);

            comm.ExecuteNonQuery();

            sqlC.Close();

            Filltab2();

        } 

        private void button8_Click(object sender, EventArgs e)

        {

            if ((textBox7.Text == "") | (textBox8.Text == "")) return;           

            sqlC.Open();

            comm = new SqlCommand(@"INSERT INTO Discont

                                 (discontNo, discount)

                                VALUES      (" + textBox7.Text + ", " + textBox8.Text + ")", sqlC);

            comm.ExecuteNonQuery();

            sqlC.Close();

            Filltab2();

        } 

        private void button7_Click(object sender, EventArgs e)

        {

            string i = Convert.ToString(dataGridView5.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value);

            comm = new SqlCommand(@"DELETE FROM Discont

                                    WHERE (discontNo = " + (i) + ")", sqlC);

            comm.ExecuteNonQuery();

            Filltab2();

        } 

        private void button10_Click(object sender, EventArgs e)

        {

            if(comboBox5.SelectedIndex <=0)return;

            sqlC.Open();

            comm = new SqlCommand(@"DELETE FROM Firm

                                    WHERE (id = " + comboBox5.SelectedIndex.ToString() + ")", sqlC);

            comm.ExecuteNonQuery();

            sqlC.Close();

            Filltab3();

        } 

        private void button9_Click(object sender, EventArgs e)

        {

            sqlC.Open();

            comm = new SqlCommand(@"SELECT MAX(id) FROM Merchans", sqlC);

            int id = Convert.ToInt32(comm.ExecuteScalar()) + 1;

            comm = new SqlCommand(@"INSERT INTO Firm

                        (id, Firm)

                        VALUES      ("+ Convert.ToString(id) +", N'"+ textBox8.Text +"')", sqlC);

            comm.ExecuteNonQuery();

            sqlC.Close();

            Filltab3();

        } 

        private void button12_Click(object sender, EventArgs e)