C# - WebService. I am having issue extracting data by plugging a value into a web service help page textbox in the Browser.

Hi everyone,

I built a project as part of a book learning VS2003.net.  The chapter is concerned with creating a web Service.  There are 3 methods that work on my virtual local host except for the one that takes a parameter via a textbox on the web service help page and the invoke button for it. Here are 2 methods.  The first one works fine and poulates the XML from the query which take no partamters and fills the returned browser page.  The second method which is very similar doesn't return anything.  I'm clueless.  Here are the 2 methods...


[WebMethod]
            public  DataSet GetCustomers()
            {

                  // Get Connection
                  SqlConnection cn = new SqlConnection
                        (@"database=northwind;server=.\NetSDK;Integrated Security=SSPI");

                  // Get DataAdapter
                  SqlDataAdapter da = new SqlDataAdapter("SELECT * from Customers", cn);
                  
                  // Create a DataSet
                  DataSet ds = new DataSet();

                  // Fill DataSet
                  da.Fill(ds, "Customers");

                  // Return DatSet
                  return ds;
            }


AND this one which doesn't work...

// This Does NOT WORK!!!!
            [WebMethod]
            public DataSet GetCustomersByID( string ID )
            {
                  // Get Connection
                  SqlConnection cn = new SqlConnection
                        (@"database=northwind;server=.\NetSDK;Integrated Security=SSPI");
                  
                  // Get DataAdapter
                  SqlDataAdapter da = new SqlDataAdapter("SELECT * from Customers where CustomerID = @CustomerID", cn);
                  
                  da.SelectCommand.Parameters.Add("@CustomersID", SqlDbType.VarChar, 30).Value = ID;
                  

                  // Create new DataSet
                  DataSet ds = new DataSet();

                  // Fill DataSet
                  da.Fill(ds, "Customers");

                  // Return DataSet
                  return ds;
            }

I have this in my web config file...
   <!--  GLOBALIZATION
          This section sets the globalization settings of the application.
    -->
    <globalization
            requestEncoding="utf-8"
            responseEncoding="utf-8"
   />
      <webServices>
            <protocols>
                  <add name="HttpSoap1.2"/>
                  <add name="HttpSoap"/>
                  <add name="HttpPost"/>
                  <add name="HttpGet"/>
                  <add name="HttpPostLocalhost"/>
                  <add name="Documentation"/>
            </protocols>
      </webServices>
      
 </system.web>

It appears like the string is being passed into the method.

Let me please express my gratitude for you help in advance.

Best regards,

Dynotoe