private static bool CheckDatabaseExists( string databaseName){{string sqlCreateDBQuery;bool result = false;try{SqlConnection tmpConn = new SqlConnection(@Data Source=(localdb)\ProjectsV13;Initial Cat...
private static bool CheckDatabaseExists( string databaseName)
{
{ string sqlCreateDBQuery; bool result = false; try { SqlConnection tmpConn = new SqlConnection(@"Data Source=(localdb)\ProjectsV13;Initial Catalog=Example;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False;"); sqlCreateDBQuery = string.Format("SELECT database_id from sys.databases WHERE Name = '{0}'", databaseName); using (tmpConn) { using (SqlCommand sqlCmd = new SqlCommand(sqlCreateDBQuery, tmpConn)) { tmpConn.Open(); object resultObj = sqlCmd.ExecuteScalar(); int databaseID = 0; if (resultObj != null) { int.TryParse(resultObj.ToString(), out databaseID); } tmpConn.Close(); result = (databaseID > 0); } } } catch (Exception ex) { result = false; } return result; }
}
沃梦达教程
本文标题为:c#检测是否存在数据库(SQL SERVER)
猜你喜欢
- unity 鼠标移入弹出UI的操作 2023-04-10
- unity实现屏幕上写字效果 2023-01-27
- C# 抓图服务的实现 2023-03-28
- C#端口扫描器的编写方法 2023-06-27
- Unity调用打印机打印图片 2023-02-02
- c#实现从字符串数组中把数字的元素找出来 2022-11-28
- c# WPF中的TreeView使用详解 2023-04-09
- C#串口通信模块使用方法示例 2023-02-25
- C#实现Oracle批量写入数据的方法详解 2023-07-05
- C#求点集的最小包围矩形 2023-03-10