public void Window_Loaded(object sender, RoutedEventArgs e)
{
//DataSet dataSet = new DataSet();
string connectionString = @"Data Source=ROTE\SQLEXPRESS;Initial Catalog=Birja_Truda;Integrated Security=True";
//string sqlExpression = "SELECT Position,Photo,Salary,InformationAboutWork,DateOfCreating FROM Vacansies";
//using (SqlConnection connection = new SqlConnection(connectionString))
//{
// connection.Open();
// SqlCommand command = new SqlCommand(sqlExpression, connection);
// SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
// dataAdapter.Fill(dataSet);
//dataGrid.Items = dataSet.It
//System.Windows.Data.CollectionViewSource vacansiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
//vacansiesViewSource.View.MoveCurrentToFirst();
//Labor.Birja_TrudaDataSetTableAdapters.VacansiesTableAdapter birja_TrudaDataSetVacansiesTableAdapter = new SqlDataAdapter(command);
//birja_TrudaDataSetVacansiesTableAdapter.Fill(birja_TrudaDataSet.Vacansies);
//System.Windows.Data.CollectionViewSource vacansiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
//vacansiesViewSource.View.MoveCurrentToFirst();
Labor.Birja_TrudaDataSet birja_TrudaDataSet = ((Labor.Birja_TrudaDataSet)(this.FindResource("birja_TrudaDataSet")));
this.birja_TrudaDataSet = birja_TrudaDataSet;
// Загрузить данные в таблицу Vacansies. Можно изменить этот код как требуется.
birja_TrudaDataSetVacansiesTableAdapter.Fill(birja_TrudaDataSet.Vacansies);
System.Windows.Data.CollectionViewSource vacansiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
this.vacansiesViewSource = vacansiesViewSource;
vacansiesViewSource.View.MoveCurrentToFirst();
//new SqlConnection(connectionString).Open();
}
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;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
Labor.Birja_TrudaDataSet birja_TrudaDataSet = ((Labor.Birja_TrudaDataSet)(this.FindResource("birja_TrudaDataSet")));
// Загрузить данные в таблицу Vacansies. Можно изменить этот код как требуется.
// DataTable positionVacansies = new DataTable();
// positionVacansies.Columns.Add(birja_TrudaDataSet.Vacansies.PositionColumn);
// birja_TrudaDataSet.Tables.Add(positionVacansies);
// this.birja_TrudaDataSetVacansiesTableAdapter = new DataAdapter(Birja_TrudaConnectionString).Fill((DataSet)birja_TrudaDataSet);//Columns["Position"]
//new Birja_TrudaDataSetTableAdapters().Fill(birja_TrudaDataSet);
//DataColumn headerVacancies = new DataColumn("vacanciesPosition", Type.GetType("System.String"));
//headerVacancies = birja_TrudaDataSet.Vacansies.Columns;
//System.Windows.Data.CollectionViewSource vacansiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
birja_TrudaDataSetVacansiesTableAdapter.Fill(birja_TrudaDataSet.Vacansies);
System.Windows.Data.CollectionViewSource vacansiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
//for (int i = 0; i < 5; i++)
//{
// dataGrid.Columns.Add(birja_TrudaDataSet.Vacansie);
// //System.Windows.Data.CollectionViewSource vacansiesViewSource.I
//}
//var t = new DataTable();
// create column header
//foreach (string s in identifiders)
//{
// t.Columns.Add(new DataColumn(s)); // <<=== i'm expecting you don't have defined any DataColumns, haven't you?
//}
//// Add data to DataTable
//for (int lineNumber = identifierLineNumber; lineNumber < lineCount; lineNumber++)
//{
// DataRow newRow = t.NewRow();
// for (int column = 0; column < identifierCount; column++)
// {
// newRow[column] = fileContent.ElementAt(lineNumber)[column];
// }
// t.Rows.Add(newRow);
//}
//return t.DefaultView;
//foreach (DataRow row in birja_TrudaDataSet.Vacansies)
//{
// var cells = row.ItemArray;
// foreach(object cell in cells)
// {
// dataGrid.Items.Add(cell.ToString());
// }
//}
// System.Windows.Data.CollectionViewSource vacansiesViewSource =
// ((System.Windows.Data.CollectionViewSource)(this.FindResource("vacansiesViewSource")));
vacansiesViewSource.View.MoveCurrentToFirst();
this.birja_TrudaDataSet = birja_TrudaDataSet;
}
