EventArgs e)
{(textBox1.Text!= )
{. Enabled=true;
}
{. Enabled=false;
}
}
void textBox2_TextChanged (object sender, EventArgs e)
{(textBox2.Text!= )
{. Enabled=true;
}
{. Enabled=false;
}
} void textBox3_TextChanged (object sender, EventArgs e)
{(textBox3.Text!= )
{. Enabled=true;
}
{. Enabled=false;
}
}
void textBox4_TextChanged (object sender, EventArgs e)
{(textBox4.Text!= )
{. Enabled=true;
}
{. Enabled=false;
}
}
void button2_Click (object sender, EventArgs e)
{mainForm=new Form2 () ;. dataGridView1.Rows.Add (); (int i=0; i lt; mainForm.dataGridView1.RowCount; i ++)
{(mainForm.dataGridView1 [0, i] .Value == null amp; amp; mainForm.dataGridView1 [1, i] .Value == null
amp; amp; mainForm.dataGridView1 [2, i] .Value == null amp; amp; mainForm.dataGridView1 [3, i] .Value == null
amp; amp; mainForm.dataGridView1 [4, i] .Value == null)
{. dataGridView1 [0, i] .Value=textBox1.Text; .dataGridView1 [1, i] .Value=textBox2.Text; .dataGridView1 [2, i] .Value=textBox3.Text ; .dataGridView1 [3, i] .Value=textBox4.Text; .dataGridView1 [4, i] .Value=textBox5.Text; path=Application.StartupPath + Товарооборот.sdf raquo ;; conn=new SqlCeConnection ( Data Source= + path + laquo ;; Persist Security Info=True ) ;. Open (); Komanda=new SqlCeCommand (
Insert into [Супермаркет] ([Код супермаркету], [Найменування], [Адреса], [Номер телефону], [ПІБ керівника]) values ??('
+ Convert.ToInt32 (mainForm.dataGridView1 [0, i] .Value) + laquo ;, + Laquo;
+ Convert.ToString (mainForm.dataGridView1 [1, i] .Value) + laquo ;, + Laquo;
+ Convert.ToString (mainForm.dataGridView1 [2, i] .Value) + laquo ;, + Laquo;
+ Convert.ToString (mainForm.dataGridView1 [3, i] .Value) + laquo ;, + Laquo;
+ Convert.ToString (mainForm.dataGridView1 [4, i] .Value) + ') raquo ;, conn) ;. ExecuteNonQuery () ;. Close ();
}
}. dataGridView1.Rows.Add (); ();
} void textbox1_KeyPress (object sender, KeyPressEventArgs e)
{((char.IsDigit (e.KeyChar) == true) || (e.KeyChar == (char) ConsoleKey.Backspace))
{;
} {e.Handled=true; }
}
}
}
Форма виведення звіту (про співробітника):
using System;System.Collections.Generic;System.ComponentModel;System.Data;System.Drawing;System.Linq;System.Text;System.Windows.Forms;System.Data.SqlServerCe;Office =Microsoft.Office.Core; System.Reflection; Word=Microsoft.Office.Interop.Word; System.Data.SqlClient; System.Threading.Tasks; Excel=Microsoft.Office.Interop.Excel; Товарообіг
{partial class Form15: Form
{Form15 ()
{();
}
void Form15_Load (object sender, EventArgs e)
{path=Application.StartupPath + Товарооборот.sdf raquo ;; conn=new SqlCeConnection ( Data Source= + path + laquo ;; Persist Security Info=True ) ;. Open (); Komanda=new SqlCeCommand ( Select [ПІБ] from [Співробітник] raquo ;, conn); Chitatel=Komanda.ExecuteReader (CommandBehavior.CloseConnection); str; (Chitatel.Read () == true)
{= Convert.ToString (Chitatel.GetValue (0)) ;. Items.Add (str);
}
} void button3_Click (object sender, EventArgs e)
{. Close ();
} void button2_Click (object sender, EventArgs e)
{. Office.Interop.Excel.Application ExcelApp=new Microsoft.Office.Interop.Excel.Application () ;. Office.Interop.Excel.Workbook ExcelWorkBook;=ExcelApp.Workbooks.Open (@ C: /Sotr.xlsxraquo;) ;. Office.Interop.Excel.Worksheet sheet=(Microsoft.Office.Interop.Excel.Worksheet) ExcelWorkBook.Worksheets [1];
path=Application.StartupPath + ...
