protected void Page_Load(object sender, EventArgs e) { var db = new DCDataContext(); var res = db.ExecuteQuery(typeof(string), "SELECT UPPER ( FirstName) FROM Employee", new object[0]); ListBox1.DataSource = res; ListBox1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var db = new DCDataContext(); var res = db.ExecuteQuery(typeof(string), "SELECT FirstName + ' ' + SUBSTRING(LastName,1,1) + '. ' + SUBSTRING(Patronymic,1,1) + '.' FROM Employee", new object[0]); ListBox1.DataSource = res; ListBox1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, Employee.Id, Project.Name, EmployeeProject.OfficialSalary * EmployeeProject.CountDaysWork /22 as Result FROM Employee INNER JOIN EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN Project ON EmployeeProject.ProjectId = Project.Id"; var db = new DCDataContext(); db.ExecuteQuery<EmpRes>(query); GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, SUM(EmployeeProject.OfficialSalary)AS SumTotal FROM Employee INNER JOIN EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId group BY Employee.FirstName, Employee.LastName, Employee.Patronymic"; var db = new DCDataContext(); db.ExecuteQuery<string>(query); GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var query = @"SELECT Project.Name, EmployeeProject.OfficialSalary FROM Employee INNER JOIN EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN Project ON EmployeeProject.ProjectId = Project.Id ORDER BY EmployeeProject.OfficialSalary"; var db = new DCDataContext(); db.ExecuteQuery<string>(query); GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, EmployeeProject.OfficialSalary, Project.Name FROM EmployeeProject INNER JOIN Employee ON EmployeeProject.EmployeeId = Employee.Id INNER JOIN Project ON EmployeeProject.ProjectId = Project.Id WHERE (EmployeeProject.OfficialSalary > {0})"; var db = new DCDataContext(); db.ExecuteQuery<EmpRes>(query, TextBox1.Text); GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, Employee.Id, Project.Name, CAST(EmployeeProject.OfficialSalary * EmployeeProject.CountDaysWork AS float(2)) / 22 / {0} AS Result, Project.Id AS Expr1 FROM Employee INNER JOIN EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN Project ON EmployeeProject.ProjectId = Project.Id WHERE (Project.Id = {1})"; var db = new DCDataContext(); db.ExecuteQuery<Salary.EmpRes>(query, DropDownList1.SelectedValue, TextBox1.Text); GridView1.DataBind(); }