winzip icon

C3 Class & Stored Proc Generator

Submitted on: 4/15/2017 8:42:07 PM
By: Mike Cyples 
Level: Advanced
User Rating: Unrated
Compatibility: C#, VB.NET
Views: 7273
     This is a resubmission of my Class and Stored Proc Generator from a MS SQL table. In this zip file there are 2 MS SQL scripts that create a database and table and fills in that table with some cross reference info that the program uses. This was setup by someone else I just expanded (added some fields) on it's use. This program is in C# but it will generate classes in either C# or and will create the stored proc to work with that class to create a set of basic CRUD functions. This program also makes use a a splash screen. You will need to make sure your MS SQL browser service is running for it to work. Again this was originally submitted back in 2012. This is a second resubmission, seems when attempting to download the zip file a 404 error was received. I have made a few improvements since original submission. Seems I had an & in my title that was preventing the download from being accessed, that has been removed, hopefully it can be downloaded now. Thanks for your patience for those who have been trying to download it.

winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net

Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)

Other User Comments

4/10/2017 10:38:15 AMDavid

Getting an error, even though I can download from other links when logged in.

401 - Unauthorized: Access is denied due to invalid credentials.
(If this comment was disrespectful, please report it.)

4/15/2017 1:03:53 PMPsypher (from psc cd)

hi, this is IanIppolito for creator Planetsourcecode. I just wanted to let you know that the problem with the download is that there is a "security"feature in our new hosting environment that prevents unusual characters from being used in file downloads. The & in your title is causing the zip file to have an & and is triggering it. That's why people can't download it. If you change the title and re-upload it, it will fix it. Or if you want, you can email me the attachment and I can do it for you.
(If this comment was disrespectful, please report it.)

5/31/2017 12:37:02 AM

waht is user & pass for download???

(If this comment was disrespectful, please report it.)

11/14/2017 1:47:00 PMDavid

File is now downloadable, even though the title still has an & in the zip filename.

(If this comment was disrespectful, please report it.)

6/6/2018 9:44:49 AMDavid

Thank you for the code. I'm new with C#, and code example help with learning a lot.
How could I use this to help with coding a program using .accdb storage?
(If this comment was disrespectful, please report it.)

6/6/2018 11:39:31 PMMike Cyples

1st thing to do is look at the table that contains the cross reference of the datatypes., If MS Access still does not have stored procs then you will have to create queries for each of the action items in the stored proc. On the class side you just need to create the code to drive those queries in the class instead of the calls to the database.
(If this comment was disrespectful, please report it.)


Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)

To post feedback, first please login.