public Form1() { InitializeComponent(); Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub(); q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname")); coll = svc.Employees_QueryForCollection(q); this.dataGrid.DataSource = coll.Collection; }
public esDemo() { InitializeComponent(); // Create our Query Object EmployeesQueryProxyStub query = new EmployeesQueryProxyStub(); query.es.Top = 20; // Limit it to 20 query.Select(query.EmployeeID, query.FirstName, query.LastName); service.Employees_QueryForCollectionCompleted += new EventHandler<Employees_QueryForCollectionCompletedEventArgs>(service_Employees_QueryForCollectionCompleted); // Make the request on our Serivce service.Employees_QueryForCollectionAsync(query); }
private void buttonQuery_Click(object sender, EventArgs e) { Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp"); q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname")); q.Where(q.LastName.Like("%" + txtLastName.Text + "%")); q.OrderBy(q.LastName.Ascending); coll = svc.Employees_QueryForCollection(Proxies.EmployeesQueryProxyStub.SerializeHelper.ToXml(q)); if (coll == null) { coll = new EmployeesCollectionProxyStub(); } this.dataGrid.DataSource = coll.Collection; }
private void SearchButton_Click(object sender, RoutedEventArgs e) { try { Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp"); q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname")); q.Where ( q.FirstName.Like("%" + SearchTextBox.Text + "%") | q.LastName.Like("%" + SearchTextBox.Text + "%") ); service.Employees_QueryForCollectionAsync(q); WorkingBar.Value = 0; Timer.Begin(); } catch (Exception exc) { Console.WriteLine(exc.StackTrace); } }