need to create db2015-2016, db2016-2017 in sql using c#

Hi

Please check the link

http://www.codeproject.com/Articles/10213/Create-an-SQL-Server-Database-Using-Csharp

https://support.microsoft.com/en-in/kb/307283

Rajiv Sir This is my Problem

i develop small software for my shop trading shop

Are you still stuck somewhere? Is given direction not sufficient? If so, please give precise area where you are not clear so that more details can be given.

Please provide maximum information and don't assume anything anything.

nitin sir. thanx for reply.

rajiv thx for reply

I strongly suggest that do not include any special character (such has -, i.e. hyphen) in the name, it will be a headache later. Instead keep db name (also, table names, column names, etc.) simple. To give the effect of space, use _ underscore instead.

So your db name becomes db20152016, etc. Then again what is "db"? It doesn't tell anything about "function" or "business". So if this is Financial Year, call it FY20152016, etc.

Now to answer your question, all you have to do is construct a string of a SQL and fire it against a connection, by default keeping the master as your database.

For example, something as follows:

DateTime YearStart, YearEnd; // Assign appropriate values to these variables.

String query = "create database FY" + YearStart.Year.ToString() + YearEnd.Year.ToString() + ";" // add more script here if required.

I also suggest that you keep all your master tables in separate db and keep an entry of each such created db in master tables db, so that it can be used to show the drop down of years.

https://support.microsoft.com/en-us/kb/307283