本文整理汇总了C#中System.Data.SqlClient.SqlConnectionStringBuilder.Add方法的典型用法代码示例。如果您正苦于以下问题:C# SqlConnectionStringBuilder.Add方法的具体用法?C# SqlConnectionStringBuilder.Add怎么用?C# SqlConnectionStringBuilder.Add使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlConnectionStringBuilder
的用法示例。
在下文中一共展示了SqlConnectionStringBuilder.Add方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateConnection
static SqlConnection CreateConnection(string server, string db, string uname, string pass)
{
SqlConnectionStringBuilder connSB = new SqlConnectionStringBuilder();
connSB.Add("user id", uname);
connSB.Add("password", pass);
connSB.Add("server", server);
connSB.Add("database", db);
//Console.WriteLine(connSB.ConnectionString);
return new SqlConnection(connSB.ConnectionString);
}
示例2: RetornaCadenaConexionMasterDatabase
public static string RetornaCadenaConexionMasterDatabase()
{
//Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password = myPassword;
var connectionBuilder = new SqlConnectionStringBuilder();
connectionBuilder.Add("Server", Server);
connectionBuilder.Add("Database", "Master");
connectionBuilder.Add("User Id", User);
connectionBuilder.Add("Password", Password);
return connectionBuilder.ToString();
}
示例3: GetDBNames
/// <summary>
/// 获取可用数据库名
/// </summary>
/// <param name="Server">连接到的服务器</param>
/// <param name="UserName">连接用户名</param>
/// <param name="PassWord">连接密码</param>
/// <returns>可用数据库名称列表或者本地化错误信息</returns>
public static String[] GetDBNames(String Server, String UserName = null, String PassWord = null)
{
List<String> names = new List<String>();
names.Add(LocalString.NoDBNames);
try
{
SqlConnectionStringBuilder sqlCSB = new SqlConnectionStringBuilder();
sqlCSB.Add("server", "tcp:" + Server);
if (UserName == null || PassWord == null)
{
sqlCSB.Add("Integrated Security", true);
}
else
{
sqlCSB.Add("uid", UserName);
sqlCSB.Add("pwd", PassWord);
}
sqlCSB.Add("Connection Timeout", TimeOut);
SqlConnection sqlConnection = new SqlConnection(sqlCSB.ConnectionString);
sqlConnection.Open();
String SQL = @"SELECT name FROM sys.databases WHERE "
+ "name NOT IN ('master', 'tempdb', 'model', 'msdb','ReportServer','ReportServerTempDB');";
SqlCommand cmd = new SqlCommand(SQL, sqlConnection);
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
names.RemoveAll((a) => { return true; });
}
while (data.Read())
{
names.Add(data["name"].ToString());
}
data.Close();
cmd.Dispose();
sqlConnection.Close();
}
catch (Exception ex)
{
Debuger.PrintException(ex);
}
return names.ToArray();
}
示例4: Open
/// <summary>
/// 打开连接
/// </summary>
public void Open()
{
SqlConnectionStringBuilder sqlCSB = new SqlConnectionStringBuilder();
sqlCSB.Add("server", "tcp:" + Server);
sqlCSB.Add("database", DBName);
if (this.Integrated)
{
sqlCSB.Add("Integrated Security", true);
}
else
{
sqlCSB.Add("uid", User);
sqlCSB.Add("pwd", Pass);
}
sqlCSB.Add("Connection Timeout", TimeOut);
//启用多个活动结果集支持(MARS)仅SQL Server 2008及更新版本
//sqlCSB.Add("MultipleActiveResultSets", "true");
conn = new SqlConnection(sqlCSB.ConnectionString);
conn.Open();
}
示例5: TestDBConnction
/// <summary>
/// 进行测试连接
/// </summary>
/// <param name="Server">数据库服务器地址</param>
/// <param name="DataBaseName">数据库名</param>
/// <param name="UserName">数据库用户名</param>
/// <param name="PassWord">数据库密码</param>
/// <returns>是否可以连接到数据库</returns>
public static bool TestDBConnction(String Server, String DataBaseName, String UserName, String PassWord,out String Error)
{
try
{
SqlConnectionStringBuilder sqlCSB = new SqlConnectionStringBuilder();
sqlCSB.Add("server", "tcp:" + Server);
sqlCSB.Add("database", DataBaseName);
sqlCSB.Add("uid", UserName);
sqlCSB.Add("pwd", PassWord);
sqlCSB.Add("Connection Timeout", TimeOut);
SqlConnection sqlConnection = new SqlConnection(sqlCSB.ConnectionString);
sqlConnection.Open();
sqlConnection.Close();
Error = "";
return true;
}
catch (SqlException ex)
{
if (ex.Class < 17)
{
Debuger.PrintException(ex);
Error = ex.Message;
return false;
}
throw ex;
}
}