本文实例讲述了C#创建数据库及附加数据库的操作方法。分享给大家供大家参考，具体如下：
/// <summary>
/// 附加数据库方法
/// </summary>
/// <param name="strSql">连接数据库字符串，连接master系统数据库</param>
/// <param name="DataName">数据库名字</param>
/// <param name="strMdf">数据库文件MDF的路径</param>
/// <param name="strLdf">数据库文件LDF的路径</param>
/// <param name="path">安装目录</param>
private void CreateDataBase( string strSql, string DataName, string strMdf, string strLdf, string path)
{
SqlConnection myConn = new SqlConnection(strSql);
String str = null ;
try
{
str = " EXEC sp_attach_db @dbname='" +DataName+ "',@filename1='" +strMdf+ "',@filename2='" +strLdf+ "'" ;
SqlCommand myCommand = new SqlCommand(str, myConn);
myConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show( "数据库安装成功！点击确定继续" ); //需Using System.Windows.Forms
}
catch (Exception e)
{
MessageBox.Show( "数据库安装失败！" + e.Message+ "\n\n" + "您可以手动附加数据" );
System.Diagnostics.Process.Start(path); //打开安装目录
}
finally
{
myConn.Close();
}
}
public override void Install(System.Collections.IDictionary stateSaver)
{
string server = this .Context.Parameters[ "server" ]; //服务器名称
string uid = this .Context.Parameters[ "user" ]; //SQlServer用户名
string pwd = this .Context.Parameters[ "pwd" ]; //密码
string path = this .Context.Parameters[ "targetdir" ]; //安装目录
string strSql = "server=" + server + ";uid=" + uid + ";pwd=" + pwd + ";database=master" ; //连接数据库字符串
string DataName = "JXC" ; //数据库名
string strMdf = path + @"JXC.mdf" ; //MDF文件路径，这里需注意文件名要与刚添加的数据库文件名一样！
string strLdf = path + @"jxc_log.ldf" ; //LDF文件路径
base .Install(stateSaver);
this .CreateDataBase(strSql, DataName, strMdf, strLdf, path); //开始创建数据库
}
/// <summary>
/// 测试连接
/// </summary>
/// <param name="serverName"></param>
/// <param name="dbName"></param>
/// <param name="userName"></param>
/// <param name="password"></param>
private SqlConnection TestConnection( string serverName, string dbName, string userName, string password)
{
string connectionString = GetConnectionString(serverName, dbName, userName, password);
SqlConnection connection = new SqlConnection(connectionString);
try
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
return connection;
}
catch
{
CloseConnection(connection);
throw new InstallException( "安装失败!\n数据库配置有误,请正确配置信息！" );
}
}
/// <summary>
/// 得到连接字符串
/// </summary>
/// <param name="serverName"></param>
/// <param name="dbName"></param>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
private string GetConnectionString( string serverName, string dbName, string userName, string password)
{
string connectionString = "Data Source={0};Initial Catalog={1};User ID={2};Password={3}" ;
connectionString = string .Format(connectionString, serverName, dbName, userName, password);
return connectionString;
}
/// <summary>
/// 创建数据库
/// </summary>
/// <param name="serverName"></param>
/// <param name="dbName"></param>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="connection"></param>
/// <param name="stateSaver"></param>
public int CreateDataBase(SqlConnection connection)
{
int result = -1;
connection.ChangeDatabase( "master" );
string createDBSql = @" if Exists(select 1 from sysdatabases where [name]=N'{0}')
begin
drop database {0}
end
GO
CREATE DATABASE {0} " ;
createDBSql = string .Format(createDBSql, _dbName);
//因为有Go在SQLCommand中不认识，所以以Go为分隔符取sql语句
char [] split = new char [] { 'G' , 'O' };
string [] sqlList = createDBSql.Split(split);
SqlCommand command = null ;
try
{
command = connection.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
foreach ( string sqlItem in sqlList)
{
if (sqlItem.Length > 2)
{
command.CommandText = sqlItem;
result = command.ExecuteNonQuery();
}
}
return result;
}
catch
{
CloseConnection(connection);
command.Dispose();
throw new InstallException( "安装失败!\n数据库配置不正确!" );
}
}
/// <summary>
/// 分隔SQL语句
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
private string [] splitSql( string sql)
{
Regex regex = new Regex( "^GO" , RegexOptions.IgnoreCase | RegexOptions.Multiline);
string [] sqlList = regex.Split(sql.ToUpper());
return sqlList;
}
希望本文所述对大家C#程序设计有所帮助。
dy("nrwz");
查看更多关于C#创建数据库及附加数据库的操作方法的详细内容...