private void Form1_Load(object sender, EventArgs e)
{
// Create a web service proxy using the SQL Server HTTP endpoint
localhost.AdvSalesEndpoint proxy = new localhost.AdvSalesEndpoint();
// Set the integrated security credentials
proxy.Credentials = CredentialCache.DefaultCredentials;
// Bind the combo box to the results of the web method call
this.cboSalesPerson.ValueMember = "SalespersonId";
this.cboSalesPerson.DisplayMember = "FullName";
// Call the web method
this.cboSalesPerson.DataSource = proxy.GetSalespersonList().Tables[0];
}
private void cboSalesPerson_SelectedIndexChanged(object sender, EventArgs e)
{
// Create a web service proxy using the SQL Server HTTP endpoint
localhost.AdvSalesEndpoint proxy = new localhost.AdvSalesEndpoint();
// Set the integrated security credentials
proxy.Credentials = CredentialCache.DefaultCredentials;
// Bind the data grid view to the results of the web method call
this.dgvSales.DataSource = proxy.GetSalesPersonSales(new
System.Data.SqlTypes.SqlInt32((int)this.cboSalesPerson.SelectedValue)).Tables[0];
// Populate the text box with the results of the second web method call
this.txtTotalSales.Text = proxy.GetSalesTotal(new
System.Data.SqlTypes.SqlInt32((int)this.cboSalesPerson.SelectedValue)).Value.ToString("C");
}