How to connect queries from SQL Server 2005 to VB.Net Windows application
Expand Post »
Hi,
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?
Re: How to connect queries from SQL Server 2005 to VB.Net Windows application
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.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
