Option Compare Database

Private Sub Класс_вод_AfterUpdate()
Me![Класс] = Me![Класс вод].Column(1)
End Sub

Private Sub Мощность_AfterUpdate()
Me![Мощ] = Me![Мощность].Column(1)
End Sub

Private Sub Период_Исп_AfterUpdate()
Me![ПерИсп] = Me![Период Исп].Column(1)
End Sub

Private Sub Сити_AfterUpdate()
Me![Город] = Me![Сити].Column(1)
End Sub

Private Sub Страховая_компания_AfterUpdate()

p = Me![Страховая компания].Column(0)

Select Case p
Case 1
Me![Ставка] = "3432"
Case 2
Me![Ставка] = "3775"
Case 3
Me![Ставка] = "4118"
Case 4
Me![Ставка] = "3432"
Case 5
Me![Ставка] = "4118"
Case 6
Me![Ставка] = "4118"
End Select

End Sub

Private Sub Цена_Dirty(Cancel As Integer)
Me![Цена] = Me![Класс] + Me![Мощ] + Me![ПерИсп] + Me![Город] + Me![Ставка]
End Sub

            Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
             Microsoft.Office.Interop.Excel.Workbook ExcelWorkBook;
             Microsoft.Office.Interop.Excel.Worksheet ExcelWorkSheet;
             //Книга.
             ExcelWorkBook = ExcelApp.Workbooks.Add(System.Reflection.Missing.Value);
             //Таблица.
             ExcelWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ExcelWorkBook.Worksheets.get_Item(1);
   
             for (int i = 0; i < dataGridView1.Rows.Count; i++)
             {
                 for (int j = 0; j < dataGridView1.ColumnCount; j++)
                 {
                     ExcelApp.Cells[i + 1, j + 1] = dataGridView1.Rows[i].Cells[j].Value;
                 }
             }
             //Вызываем нашу созданную эксельку.
             ExcelApp.Visible = true;
             ExcelApp.UserControl = true;  

                        SqlDataReader readfile = opfile.ExecuteReader();

                         if (readfile.Read())
                         {
                             SqlBytes fileData = readfile.GetSqlBytes(0);
                             DeflateStream decompress = new DeflateStream(fileData.Stream, CompressionMode.Decompress, true);
                             FileStream fs = new FileStream(savefile,
                    FileMode.Create,
                    FileAccess.ReadWrite);
                             int sourcebyte = decompress.ReadByte();
                             while (sourcebyte != -1)
                             {
                    fs.WriteByte((byte)sourcebyte); sourcebyte = decompress.ReadByte();
                             }
                             fs.Close();
                             decompress.Close();
                             decompress = null;

   FileStream file = new FileStream(FileName, FileMode.Open, FileAccess.Read, FileShare.Read);
             byte[] buffer = new byte[file.Length];
             file.Read(buffer, 0, buffer.Length);
             file.Close();

             MemoryStream ms = new MemoryStream();

             DeflateStream compress = new DeflateStream(ms, CompressionMode.Compress, true);
             compress.Write(buffer, 0, buffer.Length);

             compress.Close();
             compress = null;
             buf = new SqlBytes(ms);