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;