using System.Data.SqlClient; class Program { static void Main() { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "localhost"; builder.InitialCatalog = "MyDatabase"; builder.IntegratedSecurity = true; // 使用Windows身份验证 string connectionString = builder...
public string TransactionBinding { get; set; } 属性值 String 为TransactionBinding 属性的值,或者,如果未提供任何值,则为 String.Empty。 注解 ConnectionString 中的事务绑定关键字控制 SqlConnection 如何绑定到登记的 Transaction。 下表列出了 TransactionBinding 属性的可能值: 展开表 “值”说明 Implicit ...
publicoverrideboolRemove(stringkeyword); 参数 keyword String 要从此SqlConnectionStringBuilder中的连接字符串移除的键/值对中的键。 返回 Boolean 如果该键存在于连接字符串中并已被移除,则为true;如果该键不存在,则为false。 例外 ArgumentNullException
usingSystem.Data.SqlClient;classProgram{staticvoidMain(){ SqlConnectionStringBuilder builder =newSqlConnectionStringBuilder("Network Address=(local);Integrated Security=SSPI;"+"Initial Catalog=AdventureWorks");// Display the connection string, which should now// contain the "Data Source" key, as opposed...
SqlConnectionsqlcon = newSqlConnection(); sqlcon.ConnectionString = connStrBuilder.ConnectionString;//转成连接字符串 sqlcon.Open(); 向已有连接字符串提供数据: connStr ="Data Source=127.0.0.1;DataBase=Hydor;UID=***;PWD=***;";varconnStrBuilder =newSqlConnectionStringBuilder(connStr);//connStr...
static void Main(string[] args) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder { DataSource = ".", UserID = "sa", Password = "123", InitialCatalog = "Db" }; Console.WriteLine(builder.ToString()); Console.ReadKey(); ...
{0}", builder.AttachDBFilename); builder.AttachDBFilename =@"C:\MyDatabase.mdf"; Console.WriteLine("Modified: "+ builder.ConnectionString);using(SqlConnection connection =newSqlConnection(builder.ConnectionString)) { connection.Open();// Now use the open connection.Console.WriteLine("Database...
("Original: "+ builder.ConnectionString);// Use the Remove method// in order to reset the user ID and password back to their// default (empty string) values.builder.Remove("User ID"); builder.Remove("Password");// Turn on integrated security:builder.IntegratedSecurity =true; Console....
指示此 SqlConnectionStringBuilder 实例中是否存在指定的键。 C# 复制 public override bool ShouldSerialize (string keyword); 参数 keyword String 要在SqlConnectionStringBuilder 中定位的键。 返回 Boolean 如果SqlConnectionStringBuilder 包含具有指定键的项,则为 true;否则为 false。 注解 此...
using System.Data.SqlClient; class Program { static void Main() { try { string connectString = "Server=(local);" + "Integrated Security=true"; SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectString); Console.WriteLine("Original: " + builder.ConnectionString);...