I have a web service which retrieves columns from a SQL Express database.

I create a windows forms client in the same solution and onthe form I place a DataGridView. I try to use the smart tags of DataGridView to choose the source of data which is the web service. The wizard successfully completes his screen saying'now should be available for the DatagridView'. When you close the wizard you still see that no data was chosen. I went thru' this a couple of times to make sure. I may post the details on my blog:
http://hodentek.blogspot.com

I think the wizard has a bug.

I positively hate bugs.

The same versions as in my previous post, all 2008 versions

I hate bugs too, but your assumption is its a bug, and you say "think" then act like you know for sure it is.

Does your code work in 2005 just not 2008?

Does your table have a primary key?

Are you sure your query actually returns data?

I was not able to reproduce this with SQL 2000, 2005 (any edition including Express).

Hi Jayaram Krishnaswamy,

We are changing the issue type to "Comment" because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to "Question" by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

Thank you!
Rong-Chun Zhang

I do not see the rdio buttons in the post ditor window.

Sorry for getting back late. For me this is still unsettled. I have gone through the process and here are some more details.

The DataGridView lets you choose from three types of sources, Database, Web Service, Object. This particular problem was noticed in trying to get data from a Web Service to a Windows Client. I am nor sure if this is somehing special to my version of VS 2008.

---------------------

Client Creation Steps:
Add a form
Add a DataGridView to the form
Configure DataGridView
--Click on Add Project Data Source
--Choose Web Service
Add Web Service
--------Add Web Reference
------------Choose Web Services in this solution

---------------------------------------------------------------------------
[ a web service in the solution is identified and added to web references]
[The Data Source Configuraion Wizard reports that "the following web reference will be added and all objects it returns will be available in the Data Sources window" with http://localhost:1098/Serive1.asmx]
You finish closing this wizard

This web reference creates two data sources,
the Service1 which only exposes the following:
Url
UseDefaultCredentials
Soap Version
--
--
etc
and the class which is named "Web Service methods name + CompletedEvenArgs"
which does not expose the method.

Hence the DataGridView's wizard does not do the tasks [BindingSource does not bind to response from web service] necessary to bring data from the Web Service method.

In the case of connecting to a DataBase it is straight forward.

Someone has suggested doing this process manually and that suggestion does not address the wizard's problem. It is probably a workaround.