sirmilt

I am using Visual Basic s010 with an SQL Server 2008 R2 Express database. I have added this database and its queries to my Visual Basic project. I later found that I needed another query.

I designed the query in the SSMS and refreshed my database and all appears to be fine.

I now need to add this query to an existing data source in my project but can't figure out how to do it There seems to be no add/delete capability for existing data sources or...I just don't know how to find it.

The Data Source menu has a "Transact SQL Editor" which give the choice of "New Query Connection" which seems to be what I am looking for, but when I click on it I got an error the first time, after that I got nothing.

Can anyone help?

Milt