Click here to Skip to main content
15,893,668 members
Articles / Database Development / SQL Server

Generate SQL Select, Insert, Update and Delete

Rate me:
Please Sign up or sign in to vote.
2.93/5 (10 votes)
29 Nov 2006CPOL2 min read 138.6K   4K   55  
This will generate a SQL Select Query, Insert Query, Update Query and Delete Query by selecting SQL Database Connection and Choose a table to generate the script for using in class or DataCommand.
Imports System
Imports System.Reflection
Imports System.Runtime.InteropServices

' General Information about an assembly is controlled through the following 
' set of attributes. Change these attribute values to modify the information
' associated with an assembly.

' Review the values of the assembly attributes

<Assembly: AssemblyTitle("GenerateSQL")> 
<Assembly: AssemblyDescription("")> 
<Assembly: AssemblyCompany("SamITCom")> 
<Assembly: AssemblyProduct("GenerateSQL")> 
<Assembly: AssemblyCopyright("Copyright © SamITCom 2006")> 
<Assembly: AssemblyTrademark("")> 

<Assembly: ComVisible(False)>

'The following GUID is for the ID of the typelib if this project is exposed to COM
<Assembly: Guid("0becb0a2-1274-43aa-9b07-e09cbeb1479f")> 

' Version information for an assembly consists of the following four values:
'
'      Major Version
'      Minor Version 
'      Build Number
'      Revision
'
' You can specify all the values or you can default the Build and Revision Numbers 
' by using the '*' as shown below:
' <Assembly: AssemblyVersion("1.0.*")> 

<Assembly: AssemblyVersion("1.0.0.0")> 
<Assembly: AssemblyFileVersion("1.0.0.0")> 

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
Indonesia Indonesia
Sam is working on .Net technologies for a reputed IT company

Comments and Discussions