How to connect queries from SQL Server 2005 to VB.Net Windows application

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jan 2007
Posts: 15
Reputation: quiptro is an unknown quantity at this point 
Solved Threads: 0
quiptro quiptro is offline Offline
Newbie Poster

How to connect queries from SQL Server 2005 to VB.Net Windows application

 
0
  #1
Apr 17th, 2007
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?

Thanks,
Robert
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,134
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 529
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: How to connect queries from SQL Server 2005 to VB.Net Windows application

 
0
  #2
Apr 17th, 2007
Go into server explorer. The queries are rather confusingly called "views" in VB.NET
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Jan 2007
Posts: 15
Reputation: quiptro is an unknown quantity at this point 
Solved Threads: 0
quiptro quiptro is offline Offline
Newbie Poster

Re: How to connect queries from SQL Server 2005 to VB.Net Windows application

 
0
  #3
Apr 17th, 2007
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC