Public Property MultipleActiveResultSets As Boolean
Dim instance As SqlConnectionStringBuilder Dim value As Boolean value = instance.MultipleActiveResultSets instance.MultipleActiveResultSets = value
public bool MultipleActiveResultSets { get; set; }
public: property bool MultipleActiveResultSets { bool get (); void set (bool value); }
/** @property */ public boolean get_MultipleActiveResultSets () /** @property */ public void set_MultipleActiveResultSets (boolean value)
public function get MultipleActiveResultSets () : boolean public function set MultipleActiveResultSets (value : boolean)
這個屬性對應至連接字串中的 "MultipleActiveResultSets" 索引鍵。這個設定只在與 SQL Server 2005 (含) 以後版本搭配使用時才有效。
下列範例明確停用對 SQL Server 2005 程式設計時可用的 Multiple Active Result Set 功能。
Imports System.Data.SqlClient Module Module1 Sub Main() Dim builder As New SqlConnectionStringBuilder builder.DataSource = "(local)" builder.IntegratedSecurity = True builder.InitialCatalog = "AdventureWorks" ' The connection does not allow multiple active result sets ' by default, so this line of code explicitly ' enables this feature. Note that this feature is ' only available when programming against SQL Server 2005 ' or later. builder.MultipleActiveResultSets = True Console.WriteLine(builder.ConnectionString) Console.WriteLine() Console.WriteLine("Press Enter to continue.") Console.ReadLine() End Sub End Module
using System.Data.SqlClient; class Program { static void Main() { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "(local)"; builder.IntegratedSecurity = true; builder.InitialCatalog = "AdventureWorks"; // The connection does not allow multiple active result sets // by default, so this line of code explicitly // enables this feature. Note that this feature is // only available when programming against SQL Server 2005 // or later. builder.MultipleActiveResultSets = true; Console.WriteLine(builder.ConnectionString); Console.WriteLine(); Console.WriteLine("Press Enter to continue."); Console.ReadLine(); } }
Windows 98、 Windows 2000 SP4、 Windows Millennium Edition、 Windows Server 2003、 Windows XP Media Center Edition、 Windows XP Professional x64 Edition、 Windows XP SP2、 Windows XP Starter Edition
.NET Framework 並不支援各種平台的所有版本。如需支援平台版本的相關資訊,請參閱系統需求一節的內容。