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 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();
}
