C#中使用SQLDMO的StoredProcedure对象(存储过程)创建数据表

关注

原创最新推荐文章于 2021-09-10 10:34:25 发布 1.7k 阅读 AI 写同款· GEO 优化 ›

一个基于C# +MySql实现的Stored Procedures 输入输出参数（IN,OUT, and INOUT）源码例子一个基于C# +MySql实现的Stored Procedures 输入输出参数IN,OUT, and INOUT parameters源码例子立即下载

                .......
                SQLDMO.StoredProcedure strProc = new SQLDMO.StoredProcedure();
                // Assign a name to stored procedure
                strProc.Name = "createCustomerTable";
                // Write a Stored Procedure Script and pass it as a string.
                strProc.Text = "CREATE procedure createCustomerTable as begin " +
                    "CREATE TABLE [ChangeMemberID] ([CusID] [int] NOT NULL ,[ChangeDate] [smalldatetime] NULL ,"+
                 "[MIDO] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,"+
                 "[MIDN] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] " +
                    "END";
                // Add the Stored Procedure to Database
                nDB.StoredProcedures.Add(strProc);
                // Execute the stored procedure to create table
                nDB.ExecuteImmediate("createCustomerTable", 0, 0);

                /* Remove the stored procedure from database. The index starts from 1.*/
                foreach (SQLDMO.StoredProcedure tmpSP in nDB.StoredProcedures)
                {
                    //find the StoredProcedure named "createCustomerTable"
                    if (tmpSP.Name == "createCustomerTable")
                    {
                        nDB.StoredProcedures.Remove(tmpSP.ID, "");
                        break;
                    }
                }