Click here to Skip to main content
15,885,546 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: string in sql statement Pin
eyeseetee6-Dec-07 2:49
eyeseetee6-Dec-07 2:49 
GeneralRe: string in sql statement Pin
eyeseetee6-Dec-07 3:02
eyeseetee6-Dec-07 3:02 
GeneralRe: string in sql statement Pin
Abhijit Jana6-Dec-07 3:26
professionalAbhijit Jana6-Dec-07 3:26 
GeneralTCP/IP - Sockets Pin
half-life6-Dec-07 1:56
half-life6-Dec-07 1:56 
GeneralRe: TCP/IP - Sockets Pin
Andre Azevedo6-Dec-07 2:03
Andre Azevedo6-Dec-07 2:03 
GeneralRe: TCP/IP - Sockets Pin
half-life6-Dec-07 2:07
half-life6-Dec-07 2:07 
GeneralRe: TCP/IP - Sockets Pin
Mike Dimmick6-Dec-07 3:09
Mike Dimmick6-Dec-07 3:09 
GeneralRe: TCP/IP - Sockets Pin
half-life6-Dec-07 3:58
half-life6-Dec-07 3:58 
GeneralChange cell color of dataGridView Pin
M Riaz Bashir6-Dec-07 1:35
M Riaz Bashir6-Dec-07 1:35 
GeneralRe: Change cell color of dataGridView Pin
Sathesh Sakthivel6-Dec-07 1:39
Sathesh Sakthivel6-Dec-07 1:39 
QuestionFormDats (width, height, ...) save to XML for Dual-Monitors Pin
merlin.AT6-Dec-07 1:29
merlin.AT6-Dec-07 1:29 
QuestionFtp over Ftp Proxy GetResponse() error Pin
Springtime6-Dec-07 1:22
Springtime6-Dec-07 1:22 
GeneralRe: Ftp over Ftp Proxy GetResponse() error Pin
Sam Xavier17-Jan-08 23:47
Sam Xavier17-Jan-08 23:47 
GeneralList of Countries Pin
nagendrathecoder6-Dec-07 1:21
nagendrathecoder6-Dec-07 1:21 

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.