setSelectMethod Method (SQLServerDataSource)
Sets the default cursor type that is used for all result sets that are created by using this SQLServerDataSource object.
The selectMethod is the default cursor type that is used for a result set. This property is useful when you are dealing with large result sets and do not want to store the whole result set in memory on the client side. By setting the property to "cursor," you can create a server-side cursor that can fetch smaller chunks of data at a time. If the selectMethod property is not set, getSelectMethod returns the default value of "direct".