如何在C＃中使用存储过程在SQL Server 2012中创建DATABASE？ Asp.net（网络） [英] How can I create DATABASE in SQL server 2012 using stored procedure in C#? Asp.net (web)

问题描述

嗨。我正在尝试使用c＃asp.net创建数据库，但我无法。任何人都可以帮助我。



我尝试了什么：



这是我的c＃asp.net程序，它执行得很好，数据库存储在数据库表中但数据库没有创建。请告诉我我的存储过程如何使用存储过程创建数据库，以便我通过程序和数据库传递值将使用存储过程在数据库中创建。我尝试，它不是通过存储过程，请告诉我存储过程或更正此。

Hi.I'm trying to create database using c# asp.net,but I can't.Can any one help me here.

What I have tried:

Here is my c# asp.net program it's execute well and data store in database table but database is not creating.Kindly tell me stored procedure that how can i create database using stored procedure so that i pass value through program and database will be created in database using stored procedure.here i try,it is not through stored procedure,kindly tell me stored procedure or correct this one.

 public void create(PropertyService p)
    {
        cnn.Open();
        cmd2 = new SqlCommand("SELECT User_ID FROM tbl_user WHERE User_Name='" + p.userDB + "'", cnn);
        string id = cmd2.ExecuteScalar().ToString();
        int ID = Int32.Parse(id);
        cmd = new SqlCommand("createDB", cnn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@DbName", p.dbname);
        string str;
        
            str = "CREATE DATABASE '" + p.dbname + "' ON PRIMARY"
    + "(Name= '" + p.dbname + "', filename = 'C:\\mysql\\ '" + p.dbname + "'.mdf', size=3,"
    + "maxsize=5, filegrowth=10%)log on"
    + "(name= '" + p.dbname + "', filename='C:\\mysql\\ '" + p.dbname + "'.ldf',size=3,"
    + "maxsize=20,filegrowth=1)";
            SqlCommand myCommand = new SqlCommand(str, cnn);
            cmd.Parameters.AddWithValue("@Description", p.description);
            cmd.Parameters.AddWithValue("@Date", p.dbdate);
            cmd.Parameters.AddWithValue("@user", ID);
            cmd.ExecuteNonQuery();
            cmd2.ExecuteNonQuery();
            myCommand.ExecuteNonQuery();
            cnn.Close();
        
        
      

    }
}

连接字符串等定义如上，每件事都是工作正常，但问题是database.thanks

connection string etc define above,every thing is working fine but issue is database.thanks

推荐答案

您好，请参阅这些文章，这有助于您解决问题，

1. a href =http://www.codeproject.com/Articles/10213/Create-an-SQL-Server-Database-Using-Csharp>使用C＃创建SQL Server数据库 [ ^ ]

2. https://support.microsoft.com/en-in/kb/307283 [ ^ ]

Hi, refer these articles, which helps you to solve your issue,
1. Create an SQL Server Database Using C#[^]
2. https://support.microsoft.com/en-in/kb/307283[^]

这篇关于如何在C＃中使用存储过程在SQL Server 2012中创建DATABASE？ Asp.net（网络）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！