public partial class _Default : System.Web.UI.Page {

    SForceAPI.SforceService binding;


    protected void Page_Load( object sender, EventArgs e ) {


        Login();
        if ( binding != null )
            GetCommunications();
    }

    #region Select a few columns from all communications
    public void GetCommunications() {
        
        string queryString = "Select Close_Date__c, Close_Rsn__c, CreatedById, CreatedDate, Date_Offer_Made__c, Days_Evaluating__c, Days_Till_Offer__c, Dt_1st_Phone_Intvw__c, Id, LastModifiedById, LastModifiedDate, Match_Comm_HF_Opp__c, Match_Comm_Stat_Form__c, Port_Dt_AP_Appl_Lst_View__c from Matching_Communications__c";

        // **** CRASH IS BELOW THIS LINE ****
        QueryResult qr = binding.query( queryString );
        // **** CRASH IS ABOVE THIS LINE ****


        // Get the returned records 
        sObject[] records = qr.records;

        // Determine whether some records where returned 
        if ( records.Length > 0 ) {
            bool done = false;  // Use this for loop control 
            while ( !done ) {
                for ( int i = 0; i < records.Length; i++ ) {
                    SForceAPI.Matching_Communications__c comm = records[ i ] as SForceAPI.Matching_Communications__c;
                    if ( comm != null )
                        Response.Write( comm.AP_Appl_Type__c + "<br>" +
                            comm.Child_Care_Assess__c + "<br>" +
                            comm.CreatedDate + "<br>" +
                            comm.Name + "<br>" +
                            comm.Id + "<br>" +
                            comm.VRMC1_1__c + "<br>"
                            );
                }
                // Update the loop control 
                done = qr.done;
                // Determine whether we need to retrieve another batch of result records 
                if ( done == false ) {
                    qr = binding.queryMore( qr.queryLocator );
                    records = qr.records;
                } else {
                    done = qr.done;
                }
            }
        } else {
            System.Diagnostics.Trace.WriteLine( "no records matched criteria" );
        }
    }
    #endregion

    #region Login()

    protected bool Login() {

        // from salesforce.com Custom Tab
        string sessionId = Request.QueryString[ "sessionid" ];
        string serverURL = Request.QueryString[ "serverurl" ];

        // declare for all messages below
        string v_message = "";

        // make sure there are values
        if ( sessionId == null || sessionId == "" )
            v_message += "SessionId is missing or blank.<br>";

        if ( serverURL == null || serverURL == "" )
            v_message += "ServerURL is missing or blank.<br>";

        if ( v_message != "" ) {
            Response.Write( v_message );
            return false;
        }


        try {
            Uri uri = new Uri( serverURL );
            if ( !uri.AbsoluteUri.StartsWith( "https://" ) ||
                    !uri.Host.EndsWith( "salesforce.com" ) ||
                    !( uri.Query == "" ) ) {
                // protect against spoofing web request
                // begins with https
                // host ends in salesforce.com
                // does not have a querystring
                Response.Write( "Not a valid API Server URL.<br><br>" + serverURL );
                return false;
            }

            // binding
            binding = new SForceAPI.SforceService();
            binding.SessionHeaderValue = new SForceAPI.SessionHeader();
            binding.SessionHeaderValue.sessionId = sessionId;
            binding.Url = serverURL;

            // TEST a SOAP call
            SForceAPI.GetUserInfoResult userInfoResult = binding.getUserInfo();

            // string userid = userInfoResult.userId;
            // check if user is in your database
            // if not, you can present a signup screen
            Response.Write( userInfoResult.userId + "<br />" );
            Response.Write( userInfoResult.userFullName + "<br />" );
            Response.Write( userInfoResult.userUiSkin + "<br />" );
            Response.Write( userInfoResult.organizationName + "<br />" );
            Response.Write( userInfoResult.currencySymbol + "<br />" );
            Response.Write( userInfoResult.ToString() + "<br />" );

            return true;

        } catch ( System.Web.Services.Protocols.SoapException exsoap ) {
            if ( exsoap.Code.ToString().Contains( "API_DISABLED_FOR_ORG" ) ) {
                v_message += "This edition of salesforce.com does not provide API access.<br>"
                    + "API access is a standard feature of Enterprise "
                    + "and Unlimited Editions.<br>"
                    + "Certify your application to gain API access to "
                    + "Professional Edition as well.<br><br>";
            }
            Response.Write( v_message + exsoap.Message );
        } catch ( System.UriFormatException uriEx ) {
            Response.Write( "The Server URL is invalid.<br><br>" + uriEx.Message );
        } catch ( Exception ex ) {
            Response.Write( "Unable to connect to the API.<br><br>" + ex.Message );
        }

        return false;
    }

    #endregion

}