You cannot obtain data by using the DataGrid component when you bind a DataGrid control to a DataSet object that is returned from a Web service (317427)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Create a new Web service project in Microsoft Visual Basic .NET.
2. On the View menu, click Server Explorer, and then connect to the Microsoft SQL Server Northwind sample database.
3. Drag the Categories table to Service1.asmx.vb. Notice that two controls (SqlConnection1 and SqlDataAdapter1) are added to the Web Form.
4. On the Data menu, click Generate Dataset to generate a new DataSet. Click to select the Add this to the designer check box to include an instance in the designer.
5. Right-click the Web Form, and then click View Code. Add the following code to Public Class Service1:

   <WebMethod()> Public Function getdata() As DataSet1
           Me.SqlDataAdapter1.Fill(DataSet11)
           Return DataSet11
       End Function
   					

6. On the Build menu, click Build Web Service1 to build the Web service.
7. Create a new Visual Basic Windows Application project, and name it TestClient.
8. Follow these steps to add a Web reference to the service project:
   1. In Solution Explorer, on the Project menu, click Add Web Reference.
   2. In the Add Web Reference dialog box, type the URL for the XML Web service in the Address box, or select the URL from the list in the Address box, and then click the arrow button.
   3. Verify that the items in the Available References box are the items that you want to reference in your project, and then click Add Reference.
9. Drag a DataSet control from the Data portion of the toolbox to the form. In the Add Dataset dialog box, click Typed dataset, and then click TestClient.localhost.DataSet1 in the Name list.
10. Drag a DataGrid control from the toolbox to the form, and then set the DataSource property of the DataGrid to DataSet11.Categories in the Properties window.
11. Add the following code to the Form Load event handler:

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            Dim x As New localhost.Service1()
    
            'Reset the instance variable DataSet11 to the DataSet that the 
            'Web service returns. To test the workaround, comment out this line.
            DataSet11 = x.getdata
    
            'Workaround 1: Retrieve the data, and then merge the data into DataSet11.
            'Dim myDS As New localhost.DataSet1()
            'myDS = x.getdata
            'DataSet11.Merge(myDS)
    
            'Workaround 2: Update the DataSource property of DataGrid1.
            'DataGrid1.DataSource = x.getdata.Categories
    
    End Sub
    					

12. Compile and run the application. Notice that the DataGrid is not populated with data. If you insert a breakpoint in the End Sub of the Load event of the form, the DataSet is displayed correctly in the Watch window.
13. To resolve this problem, comment the following line of code:

    DataSet11 = x.getdata
    						

    and uncomment one of the workarounds.