C#

1. Create class properties in C#
2. Copy the properties and paste in Notepad
3. Use find/replace to replace spaces with tabs
4. Copy the contents and paste into Excel
5. Add column for natural index (1,2,3)
6. Sort by Net Data Type
7. Add column for SQL Data Type alongside NET data type, and populate
8. Rerrange columns around to match format of CREATE TABLE syntax
9. Copy and paste the desired columns into SSMS new query window

MadMyche wrote:

I guess I'm too lazy to write the program to do it

I change over to using StreamWriter. I have used it before, I wasn't thinking.

using System.IO;
using (StreamWriter list = new StreamWriter("C:\\Users\\Gene\\Desktop\\Test.scr", true)) {

	list.WriteLine("Line " + cabinetx + "," + topy + " @" + cabinetWidth + ",0\n");
}

I changed from  Console.WriteLine( ) to  list.WriteLine( )
Works great. Beautiful thing. It doesn't print to screen but it does write to a text file.

I use progeCad. (similar to AutoCad)
I saw this online. Running script in Cad program
It draws a 1" square box. And it did it all in 1 line of code.

Line 0,0 @1,0 @0,1 @-1,0 close

Starts a line command. Space is like hitting the spacebar or Enter key.
Where do you want to start from? x,y coordinate 0,0. Space
What's the next point? @1,0. Space. and so forth

After that, I drew a cabinet, used it as a model to gather locations and sizes of Left end, right end, top, deck and measured for precise locations and sizes.
From those measurements I typed out these commands

Rectangle 0,4 @0.75,30.5
Rectangle 30,4 @-0.75,30.5
Rectangle 0.75,34.5 @28.5,-0.75
Rectangle 0.75,4 @28.5,0.75

Saved as a script file (.scr) and ran in progeCad as script file

It drew out in a split second what I had drawn previously for a model
After that, it was like candy. What other parts can I draw?

The program is two parts
First part gathers information- width, height, depth. Top drawer and 1 door, with 2 adjustable shelves. This is done thru user input, to change location, sizes and choice of parts.
Numerous windows display, allowing changes. Window is cleared and the next window is diplayed...

Second part is where all the commands code is generated. (similar to lines of code above)
I copy the command codes, paste in a text file, save as script file and run in progecad
Each line, represents one full command in progeCad. The first line runs and jumps to the next line until the end. It just drew several views of the cabinet.

Using StreamWriter, no more copy and pasting.
Thanks again.

using (StreamWriter list = new StreamWriter("C:\\Users\\Gene\\Desktop\\Test.scr", true)) {
    string content = "Line " + cabinetx + "," + topy + " @" + cabinetWidth + ",0\n";
    list.WriteLine(content);
    Console.Write(content);
}