Web service not returning data to AJAX call

See more:

Ajax

jQuery

service

web

I have been tasked with building an HTML5 website. The website will need to connect to an MS SQL database and pass data from it to the Website for the user to review. I have to build a Web Service which connects to the SQL database. The Methods I had intended to pass data to the Web page to populate a List box and to use the listbox selection populate a graph with the data. I can see the data from the IIS server and the WSDL website. I can see the data using SOAPUI if I point it at the Web address. However, when I run the AJAX script within Javascript it is not returning the data. I am puzzled.

I have attached the Webservice Code as well as the code I am using in the Javascript to call the web service.

What I have tried:

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Web.Services;
using System.Data.SqlClient;
using System.Web.Script.Serialization;





[WebService(Namespace = "http://tempuri.org/",
    Description = "Database Connection Service",
    Name = "UnivariateWebService")]
//[System.ComponentModel.ToolboxItem(false)]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
 [System.Web.Script.Services.ScriptService]

public class Service : System.Web.Services.WebService
{
    public Service () {

        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }

    [WebMethod]
    public DataSet GetBatchData()
    {

        //Modify this connection string to use your SQL Server and log on information.
        var con = new SqlConnection("server=DEVELOPMENT-SER;uid=******;pwd=******;database=UnivariateRuns");

        //Open the Customers table to serve as the parent table.
        var daRunSet = new SqlDataAdapter("Select * From dbo.Products Order By product desc",
            con);

        //Create a client-side DataSet to hold the Customers and Orders tables.
        var ds = new DataSet();

        //Explicitly open the connection to allow explicit closing.
        con.Open();

        //Fill the DataSet with the Customers table and the Orders table.
        daRunSet.Fill(ds, "Batches");
        //string myJsonString = (new JavaScriptSerializer()).Serialize(ds);     // might need to phase the dataset as a string
        //Explicitly close the connection - do not wait for garbage collection.
        con.Close();

        //Return the DataSet to the client.
        return ds;
    }

    [WebMethod]
    public DataSet GetSampleData(string product)
    {
       
        //Modify this connection string to use your SQL Server and log on information.
        var con = new SqlConnection("server=DEVELOPMENT-SER;uid=******;pwd=******;database=UnivariateRuns");

        //Open the Customers table to serve as the parent table.
        var daRunSet = new SqlDataAdapter("Select * From dbo.RunSetData where product like '%" + product + "%' Order by product desc", con);

        //Create a client-side DataSet to hold the Customers and Orders tables.
        var ds=new DataSet();

        //Explicitly open the connection to allow explicit closing.
        con.Open();

        //Fill the DataSet with the Customers table and the Orders table.
        daRunSet.Fill(ds, "RunSet");
        //daOrders.Fill(ds, "Orders");

        //Explicitly close the connection - do not wait for garbage collection.
        con.Close();

        //Return the DataSet to the client.
        return ds;
    }
    
}



Javascript Function:

function DataConnect() {
   		$.ajax({
   			type: 'GET',
   			url: 'http://192.168.1.103/Web%20Service/Service.asmx/GetBatchData',
   			dataType: 'json',
   			contentType: 'application/json;charset=utf-8',
   			success: function(responce) {
   				var names = response.d;
                 alert(names);
            },
   			failure: function(error) {
   				 alert(response.d); 
   			}
   		});
   };

// How do I get the data passed to the Plot Array from the AJAX call?