创建数据库导入sql脚本代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】创建数据库导入sql脚本

作者:雅竹 / 发布于2015/10/8/ 585


	/// <summary>
	/// 创建数据库
	/// </summary>
	/// <param name="connStr">连接字符串</param>
	/// <param name="_strDBName">数据库名称</param>
	/// <returns></returns>
	private static bool CreateDatabase(string connStr, string _strDBName)
	{
	bool bSuccess = false;
	try
	{
	 using (SqlConnection conMaster = new SqlConnection(connStr))
	 {
	 conMaster.Open();

	 // Check if the Database has existed first
	 string strExist = @"select * from dbo.sysdatabases where name='" + _strDBName + @"'";
	 SqlCommand cmdExist = new SqlCommand(strExist, conMaster);
	 SqlDataReader readerExist = cmdExist.ExecuteReader();
	 bool bExist = readerExist.HasRows;
	 readerExist.Close();
	 if (bExist)
	 {

	 string strDel = @"drop database " + _strDBName;
	 SqlCommand cmdDel = new SqlCommand(strDel, conMaster);

	 cmdDel.ExecuteNonQuery();
	 }

	 // Create the database now;
	 string strDatabase = "Create Database [" + _strDBName + "]";
	 SqlCommand cmdCreate = new SqlCommand(strDatabase, conMaster);
	 cmdCreate.ExecuteNonQuery();

	 conMaster.Close();
	 }

	 bSuccess = true;
	}
	catch (Exception e)
	{
	 throw e;
	}

	return bSuccess;
	}

试试其它关键字

　创建数据库　　导入sql脚本　

同语言下

可能有用的

雅竹贡献的其它代码(14)