Creating a SQL Server Stored Procedure Generator using WPF: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Creating a SQL Server Stored Procedure Generator using WPF

page 3 of 8

by Brian Mains
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 40064/ 75

Article Contents:

Example Application

In the example application I use Windows Presentation Foundation (WPF) to create a stored procedure generator, one that has the ability to create a select, update, delete, and insert procedure. There are some variants that would be important to have, as well as the ability to generate dynamic templates, but in this version of the code, I did not do that.

In addition, it would have been nice to use a builder approach, but for the first go around I decided to build the SQL directly in the code-behind file. It was easier to see what the needs of the application were, and made the code more easily understandable.

« (Page 2)

View Entire Article

(Page 4) »

WPF Resource Center

User Comments

Title: Good generator
Name: Nilesh Gambhava
Date: 2011-02-09 5:09:14 AM
Comment:
Thanks Libal,

I was looking professional touch stored procedure generator and my all requirements are satisfied with tools4sql.

Title: Stored Procedure Generator
Name: Libal
Date: 2010-06-24 10:24:55 AM
Comment:
I read your article, it sounds very interesting. But when I searched for more stored procedure generator, I found very interesting stored procedure generator named : T4S - Stored Procedure Generator found on www.tools4sql.net.

Thanks.....

Regards,
Libal

Title: Excellent stored procedure generator
Name: Libal
Date: 2010-06-24 10:18:02 AM
Comment:
I read this article, this article is very nice. But when I searched for more stored procedure generator, I found very intersting & excellent stored procedure generator. It has rich configuration set & it is very easy to use. its name is T4S - Stored Procedure Generator & url : www.tools4sql.net

Title: Mondal
Name: Chinmayee
Date: 2009-04-29 7:16:55 AM
Comment:
this is help ful

Title: how to get list of tables from database using vb6.0 reply
Name: Brian
Date: 2009-03-08 2:53:20 PM
Comment:
The table_name is the field returned; in VB 6, you have to use ADO recordset to loop through the rows and get the table_name field, to get the list of the tables.

Title: how to get list of tables from database using vb6.0
Name: Madhuri
Date: 2009-03-02 2:43:20 AM
Comment:
query1 = "select table_name as Name from INFORMATION_SCHEMA.Tables where TYPE ='S'"
wht next how to get the list of tables

Title: sql server
Name: deepa
Date: 2008-10-22 6:45:33 AM
Comment:
it's good to way of teaching

Title: Great example
Name: gabo
Date: 2008-09-01 3:59:25 PM
Comment:
As a matter of fact I use it all the time. Thanks.

Title: A good start
Name: Ralph D. Wilson II
Date: 2007-09-19 10:36:05 AM
Comment:
This presents a good start toward creating Stored Procs; however, I can see several limitations in it. Perhaps the most glaring limitation is the fact that it appears to only facilitate the creation of very basic SP's and, while that is useful, I am assisting C#/ASP.Net developers in the creation of much more complex SP's.

Title: Useful
Name: Niall
Date: 2007-08-30 3:32:49 AM
Comment:
This is interesting and I can see a very good use for this type of programming in my current project. One reservation I have though is the use of the WPF. Specifically the Presentation part of WPF.

Title: Code is Attached
Name: Brian Mains
Date: 2007-08-26 7:26:33 PM
Comment:
The code is attached; see the downloads section.

Title: download this software
Name: ankti
Date: 2007-08-26 4:22:23 PM
Comment:
i want to see this software