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();
}
}
connection string etc define above,every thing is working fine but issue is database.thanks