Click here to Skip to main content
15,891,654 members
Home / Discussions / C#
   

C#

 
GeneralRe: Accessing an instance of a form within an Application Pin
Bert delaVega6-Dec-07 8:14
Bert delaVega6-Dec-07 8:14 
GeneralRe: Accessing an instance of a form within an Application Pin
Naz6-Dec-07 8:34
Naz6-Dec-07 8:34 
GeneralRe: Accessing an instance of a form within an Application Pin
Bert delaVega6-Dec-07 9:18
Bert delaVega6-Dec-07 9:18 
GeneralRe: Accessing an instance of a form within an Application Pin
Pete O'Hanlon6-Dec-07 8:47
mvePete O'Hanlon6-Dec-07 8:47 
GeneralRe: Accessing an instance of a form within an Application Pin
Justin Perez6-Dec-07 9:27
Justin Perez6-Dec-07 9:27 
GeneralRe: Accessing an instance of a form within an Application Pin
Pete O'Hanlon6-Dec-07 9:54
mvePete O'Hanlon6-Dec-07 9:54 
GeneralTCP/IP - Sockets Problem Pin
half-life6-Dec-07 5:32
half-life6-Dec-07 5:32 
GeneralRe: TCP/IP - Sockets Problem Pin
Ennis Ray Lynch, Jr.6-Dec-07 5:47
Ennis Ray Lynch, Jr.6-Dec-07 5:47 
GeneralRe: TCP/IP - Sockets Problem Pin
led mike6-Dec-07 6:56
led mike6-Dec-07 6:56 
GeneralPlease help Pin
Shani Aulakh6-Dec-07 5:25
Shani Aulakh6-Dec-07 5:25 
GeneralRe: Please help Pin
Paul Conrad6-Dec-07 12:37
professionalPaul Conrad6-Dec-07 12:37 
Questionmatching words with spelling mistakes Pin
mshahrouri6-Dec-07 3:55
mshahrouri6-Dec-07 3:55 
GeneralRe: matching words with spelling mistakes Pin
Nagy Vilmos6-Dec-07 4:36
professionalNagy Vilmos6-Dec-07 4:36 
GeneralRe: matching words with spelling mistakes Pin
Ennis Ray Lynch, Jr.6-Dec-07 6:42
Ennis Ray Lynch, Jr.6-Dec-07 6:42 
GeneralMultiline TextBox problem. Pin
Neuro_pl6-Dec-07 3:53
Neuro_pl6-Dec-07 3:53 
QuestionRead Class information in C# Pin
Abhijit Jana6-Dec-07 3:22
professionalAbhijit Jana6-Dec-07 3:22 
GeneralRe: Read Class information in C# Pin
Skippums6-Dec-07 3:52
Skippums6-Dec-07 3:52 
GeneralRe: Read Class information in C# Pin
Abhijit Jana6-Dec-07 17:21
professionalAbhijit Jana6-Dec-07 17:21 
GeneralRe: Read Class information in C# Pin
Ennis Ray Lynch, Jr.6-Dec-07 8:53
Ennis Ray Lynch, Jr.6-Dec-07 8:53 
GeneralUpdate MS Access Data Structure Pin
polishprogrammer6-Dec-07 3:16
polishprogrammer6-Dec-07 3:16 
GeneralRe: Update MS Access Data Structure Pin
led mike6-Dec-07 7:08
led mike6-Dec-07 7:08 
GeneralRe: Update MS Access Data Structure Pin
polishprogrammer6-Dec-07 9:34
polishprogrammer6-Dec-07 9:34 
It answers the question at face value, more or less. My question had to do more with the mechanism for updating the database from C# code. I brushed up on my SQL a bit this morning and found the ALTER TABLE ADD COLUMNNAME command which works if I always know exactly what column names to add, but I want to automate the process.

Basically, I'm look to set up a mechanism that will search all the tables in the database if the software version has changed and compare the table definition for each table in the existing database with the table definition for each and every table in the database that will deploy with the newer version of the software to determine if there are any changes to the database. If so, then I need to execute the ALTER TABLE ADD COLUMNNAME command to add those new fields to the existing database.

Now, I can perform this process through some brute force type of programming, where I get the schema for each table in the newer version of the DB, compare it to the scheme for each table in the existing version of the DB, and then update the data accordingly, but if there's a more efficient way to accomplish the task, I would be glad to hear it.
QuestionHow to Counter Sign in various levels Pin
Member 36551006-Dec-07 3:03
Member 36551006-Dec-07 3:03 
Generalstring in sql statement Pin
eyeseetee6-Dec-07 2:18
eyeseetee6-Dec-07 2:18 
GeneralRe: string in sql statement Pin
Skippums6-Dec-07 2:29
Skippums6-Dec-07 2:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.