I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in the Data Set. The queries exist in the solution but I can't see them in the Data Set I used for the tables. Can I somehow connect the existing queries to the form?


Go into server explorer. The queries are rather confusingly called "views" in VB.NET

Thanks! I deleted the queries from the Solution Explorer and rewrote them as views in the Server Explorer and after I created a new DataSet in VB.Net, I was able to access the queries just like the tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.