Time Out 访问数据库超时处理 .NET

 1 using System.Reflection;
 2 
 3 using System.Data.SqlClient;
 4 
 5  
 6 
 7      
 8 
 9             TransactionSelectTableAdapter adapter = new TransactionSelectTableAdapter();
10 
11             Type adapterType = adapter.GetType();
12 
13             PropertyInfo commandProperty = adapterType.GetProperty("CommandCollection", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance);
14 
15             SqlCommand[] commandList = (SqlCommand[])commandProperty.GetValue(adapter, null);
16 
17             commandList[0].CommandTimeout = 3000;