Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- namespace Lab06
- {
- public partial class Form1 : Form
- {
- private MyViewDataContext db;
- public Form1()
- {
- InitializeComponent();
- db = new MyViewDataContext();
- }
- private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- var query_ex1 = from d in db.myViews select d;
- dataGridView1.DataSource = query_ex1;
- var query_ex2 = from s in db.myViews
- group s by s.DeparmentName into g
- select new { Department_Name = g.Key, Max_Salary = g.Max(s => s.Rate) };
- dataGridView2.DataSource = query_ex2;
- var query_ex3 = from s in db.myViews
- group s by s.DeparmentName into g
- let maxSalary=g.Max(a => a.Rate)
- select new
- {
- Department_Name = g.Key,
- Employee_Name = g.First(s => s.Rate == maxSalary).Name,
- Max_Salary = maxSalary
- };
- dataGridView3.DataSource = query_ex3;
- var query_ex4 = from view in db.myViews
- join sales in db.SalesPersons
- on
- select new
- {
- Employee_Name = view.Name,
- };
- dataGridView4.DataSource = query_ex4;
- }
- private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- private void label1_Click(object sender, EventArgs e)
- {
- }
- private void textBox1_TextChanged(object sender, EventArgs e)
- {
- }
- private void dataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- private void dataGridView4_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement