private void Window_Loaded(object sender, RoutedEventArgs e)
{
Labor.Birja_TrudaDataSet birja_TrudaDataSet = ((Labor.Birja_TrudaDataSet)(this.FindResource("birja_TrudaDataSet")));
// Загрузить данные в таблицу Aplicants. Можно изменить этот код как требуется.
Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter birja_TrudaDataSetAplicantsTableAdapter = new Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter();
birja_TrudaDataSetAplicantsTableAdapter.Fill(birja_TrudaDataSet.Aplicants);
System.Windows.Data.CollectionViewSource aplicantsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("aplicantsViewSource")));
aplicantsViewSource.View.MoveCurrentToFirst();
}
public WorkSpace()
{
InitializeComponent();
ImageBrush myBrush = new ImageBrush();
myBrush.ImageSource = new BitmapImage(new Uri(BaseUriHelper.GetBaseUri(this), "background.jpg"));
this.Background = myBrush;
Labor.Birja_TrudaDataSet birja_TrudaDataSet = ((Labor.Birja_TrudaDataSet)(this.FindResource("birja_TrudaDataSet")));
Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter birja_TrudaDataSetAplicantsTableAdapter = new Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter();
birja_TrudaDataSetAplicantsTableAdapter.Fill(birja_TrudaDataSet.Aplicants);
this.birja_TrudaDataSet = birja_TrudaDataSet;
this.birja_TrudaDataSetAplicantsTableAdapter = birja_TrudaDataSetAplicantsTableAdapter;
}
private void Open_Excel(object sender, RoutedEventArgs e)
{
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
Labor.Birja_TrudaDataSet birja_TrudaDataSet = ((Labor.Birja_TrudaDataSet)(this.FindResource("birja_TrudaDataSet")));
Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter birja_TrudaDataSetAplicantsTableAdapter = new Labor.Birja_TrudaDataSetTableAdapters.AplicantsTableAdapter();
birja_TrudaDataSetAplicantsTableAdapter.Fill(birja_TrudaDataSet.Aplicants);
for (int i = 0; i < birja_TrudaDataSet.Aplicants.Count; i++)
{
//for (int j = 1; j < 6; i++)
{
currentSheet.Cells[i + 1, 1] = birja_TrudaDataSet.Aplicants[i][2].ToString(); //count//.birja_TrudaDataSet.Aplicants.
// currentSheet.Cells[i + 1, 2] = birja_TrudaDataSet.Aplicants[i][2].ToString(); }
}
}
ExcelApplication.Visible = true;
}
