Building a SQLXML Web Service Application "  Chapter 7 331 proxyShow = new localhost.soapSQL(); proxyShow.LogIn(int.Parse(selEmp.SelectedItem.Value),int.Parse (selPro.SelectedItem.Value),now,out returnValue); dsT = proxyShow.showTrack(out returnValueT); dgTrack.DataSource = dsT; dgTrack.DataBind(); } } } The first key piece you need to have in place in order for this page to exe- cute properly is to declare a variable of type localhost.soapSQL, which is just the name of the Web reference.This is done at the top of the page; by doing this you can use this variable through your class to instantiate all of the Web Service methods made available to you via SQL. If we look again at the PageLoad class in Figure 7.19 as part of the start.aspx code behind you can see this in action. Figure 7.19 start.aspx Code Behind private void Page_Load(object sender, System.EventArgs e) { if(!IsPostBack) { proxyShow = new localhost.soapSQL(); dsJ = proxyShow.showJobs(out returnValueJ); selPro.DataSource = dsJ; selPro.DataBind(); dsE = proxyShow.showEmployees(out returnValueE); selEmp.DataSource = dsE; selEmp.DataBind(); dsT = proxyShow.showTrack(out returnValueT); dgTrack.DataSource = dsT; dgTrack.DataBind(); } } www.syngress.com