Solved

VB.net Get the SQL statement from a dataset

Posted on 2014-11-15
3
127 Views
Last Modified: 2014-11-16
Hi

Is it possible to get the SQL Statement text from a DataSet such as the one built at the following link?

http://msdn.microsoft.com/en-us/library/system.data.dataset_methods(v=vs.110).aspx
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 40445630
You want the SQL Statement for a dataset already opened? The answer is no. What are you trying to acheive?
0
 

Author Comment

by:murbro
ID: 40445664
Hi Eric
I have posted various questions on building a GUI for users to create table joins for SQL queries. I have built an app over the last three years that mimics the Access query creation process but am stuck on this point that no one seems to have an answer for. I hope that someone out there has at least tried to do/explain this. A simplistic interface that allows the user to drag and drop or select [Table].[Column] names and how they join to each other across a selection of tables in a query. After all if it has been done in the Access query designer, it must be possible. I had thought that using a DataSet, which allows you to programmatically add relationships might be the route
0
 

Author Closing Comment

by:murbro
ID: 40445755
Thanks Eric. That answers my question
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now