I have an ASP.Net web forms application connected to a SQL Server Database 'Db_1'.
Now, there is a button of which button click event, there will be some calculations, then create a new database 'Db_2' and store the results in the new database 'Db_2'.
How do I create the database 'Db_2'?
You can execute the below ADO.NET code to create the database.
// Creating instance of SqlConnection
SqlConnection conn = new SqlConnection(".........");
conn.Open();// open the database connection
SqlCommand cmd = new SqlCommand();// Creating instance of SqlCommand
cmd.Connection = conn; // set the connection to instance of SqlCommand
cmd.CommandText = "Create database Db_2"; // set
//the sql command ( Statement )
cmd.ExecuteNonQuery();
conn.Close();// Close the connection
Once database is create you need to create an another steps to create the table and insert the data into that table using same ADO.NET process with different SQL Server command like create table() and insert into table values ().
For the steps involved in two and three, you need to create and use another instance of the newly created database.
masterdatabase.