Query Builder
With a little practice, building SQL SELECT statements is easy. If you don’t want to compose queries yourself, however, Visual Basic includes a Query Builder to help you build them graphically. Other wizards provide access to Query Builder to help you enter SELECT statements for their own purposes. For example, at one point the Data Adapter Configuration Wizard needs you to enter a SELECT statement. If you click the Query Builder button, the wizard launches Query Builder so you can build the statement graphically.
A relatively easy way to run Query Builder is to create a new database command object. Open a new form. From the Toolbox’s Data tab, double-click the SqlCommand tool if you are using a SQL Server database or the OleDbCommand ...
Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
