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.
\r\n
\r\nI designed the query in the SSMS and refreshed my database and all appears to be fine.
\r\n
\r\nI 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.
\r\n
\r\nThe 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.
\r\n
\r\nCan anyone help?
\r\n
\r\nMilt