Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Help adding a field to MySQL table in C#

Hello-

I need the proper syntax to add a field to an existing mySQL table in C#/.NET 3.5 SP1. I have tried ALTER TABLE and UPDATE TABLE but I apparently don't have the proper syntax. So, for a table I created thusly,

            private void To6_2_0() {
                  if(FromVersion<new Version("6.2.0.0")) {
                        string command;
                        if(DataConnection.DBtype==DatabaseType.MySql) {

                    command = "DROP TABLE IF EXISTS anesthmedsintake";
                    General.NonQ(command);
                    command = @"CREATE TABLE anesthmedsintake(
                                    AnestheticMedNum int(3) NOT NULL auto_increment,
                                    IntakeDate datetime NOT NULL,
                                    AnestheticMed char (20) NOT NULL,
                                    DEASchedule char(2),
                                    Qty int(6) NOT NULL,
                                    SupplierIDNum char(11) NOT NULL,
                                    InvoiceNum char(20) NOT NULL,
                                    PRIMARY KEY (AnestheticMedNum)
                                    ) DEFAULT CHARSET=utf8";
                    General.NonQ(command);

What would the proper command later on if I want to add a new field to this table?

Thanks
0
wjstarck
Asked:
wjstarck
  • 3
  • 2
1 Solution
 
silemoneCommented:
alter the table...
0
 
silemoneCommented:
but it appears that C# doesn't allow the changing of a table structure as from this forum...so you would have to probably alter from your stored procedure
0
 
silemoneCommented:
but it appears that C# doesn't allow the changing of a table structure as from this forum...so you would have to probably alter from your stored procedure based on the number of Field Parameters...i.e. use something like in stored procedure like if columns less than the parameter string list that passed in, alter table to include new field name(s)...

http://forums.devshed.com/net-development-87/altering-a-table-in-c-176955.html
0
 
wjstarckAuthor Commented:
OK, NVM I found it. This works:

      string[] commands = new string[]
                        {
                              "ALTER table userod ADD AnesthProvType int(2) NOT NULL"
                              
                        };
                    General.NonQ(commands);
                        }
I'll give partial points to silemone for pointing me in the right direction...
0
 
wjstarckAuthor Commented:
Thanks
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now