I've been following Kevin M's thread #1309187 as it evolved, hoping it would give me the answer I want, but as luck would have it...

Anyway, let me preface this by saying that Yankee Stadium couldn't hold what I don't know about .Net.

Now, the question is, why can't I get a typed dataset to return actual data from a web service?

I'm using the AdventureWorks_Data database in MS SqlServer.

dsDept is a typed dataset created through VS 2005. It uses a stored proc to bring back the data. The stored proc is simply

Select * From HumanResources.Department where DepartmentID = @id

.

"catsnjazz" is the name of my computer.

When I execute the stored proc from VS 2005's Server Explorer, it brings back the correct data.

Here is the code for the web service stripped right down to it's knickers. I took out the business objects etc, so that it would be as simple as possible to show the problem.

Following the web service code, is the code that calls the web service (also stripped right down). It consists of a form with 4 text boxes and a button that when clicked starts the process.

So, any idea what I'm doing wrong? Don't worry about hurting my feelings if it's something really dumb. And let me point out that if I don't use a typed dataset - if I create a normal dataset, command, datatable, and adapter in my code and return the dataset, it works like I would expect and returns the data requested. With the typed dataset, all I get back is the schema with no data.

Oh, one more thing. After the line "adapter.FillByID(dt, id);" in the web service, I even tried adding "ds.AcceptChanges" and I also tried "dt.AcceptChanges", both to no avail.

// Web Service

using System;
using System.Data;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.ComponentModel;

namespace wsAwDept
{
  /// <summary>
  /// Summary description for svcAwDept
  /// </summary>
  [WebService(Namespace = "http://catsnjazz/")]
  [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  [ToolboxItem(false)]
  public class svcAwDept : System.Web.Services.WebService
  {

    [WebMethod(Description = "Returns a dataset according to desired id")]
    public DataSet GetDeptById(short id)
    {
      // create dataset (ds), datatable (dt) and table adapter (adapter)
      dsDept ds = new dsDept();
      dsDept.DepartmentDataTable dt = new dsDept.DepartmentDataTable(ds.Tables[0]);
      dsDeptTableAdapters.DepartmentTableAdapter adapter = 
        new dsDeptTableAdapters.DepartmentTableAdapter();

      // call adapter method to fill datatable according to requested id
      adapter.FillByID(dt, id);

      return ds;
    }
  }
}

// Calling program

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace awdatatest
{
	public partial class Form1 : Form
	{
		// create service, dataset and datatablereader
		catsnjazz.svcAwDept ws = new catsnjazz.svcAwDept();
		DataSet departmentDS = new DataSet();
		DataTableReader dr;

		public Form1()
		{
			InitializeComponent();
		}

		private void btnStart_Click(object sender, EventArgs e)
		{
			// create a dataset using service and id of 11
			departmentDS = ws.GetDeptById(11);
			// set the datatablereader to the table in the dataset
			dr = departmentDS.CreateDataReader(departmentDS.Tables[0]);
			
			// see if we have the right schema for the table
			MessageBox.Show(dr.GetName(0) + "\r\n" +
								dr.GetName(1) + "\r\n" +
								dr.GetName(2) + "\r\n" +
								dr.GetName(3));

			if (dr.HasRows)
			{
				// move to 1st record and display the data
				dr.Read();
				this.showData(dr);
			}
			else
			{
				// no data in the dataset - WHY NOT??
				MessageBox.Show("No rows returned");
			}
		}

		// display the data in the dataset
		private void showData(DataTableReader dr)
		{
				this.txtDepartmentID.Text = dr.GetValue(0).ToString();
				this.txtName.Text = dr.GetValue(1).ToString();
				this.txtGroupName.Text = dr.GetValue(2).ToString();
				this.txtModifiedDate.Text = dr.GetValue(3).ToString();
		}
	}
}