注意：這個屬性是 .NET Framework 2.0 版的新功能。
取得或設定布林值，指出是否可以將多個使用中結果集與相關聯的連接產生關聯。
命名空間： System.Data.SqlClient
組件： System.Data (在 system.data.dll 中)
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 屬性的值，如果未提供任何值，則為 false。
這個屬性對應至連接字串中的 "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 並不支援各種平台的所有版本。如需支援平台版本的相關資訊，請參閱系統需求一節的內容。
.NET Framework
支援版本：2.0