Adobe 38043740 Developing Applications - Page 1167

DEVELOPING COLDFUSION 9 APPLICATIONS Using Web Elements and External Objects 1162 ColdFusion Code: #item# Third element in the list is true Using ADO.Net DataTable in ColdFusion ColdFusion converts System.Data.DataTable objects to ColdFusion query objects, and you can perform all standard ColdFusion query operations on them. The following example shows this usage: .Net code: public DataTable datasetMethod() { //conn string string connectionString = "..."; //connection using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(@"SELECT * FROM [tblEmployees]", connection); connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); return dt; } } ColdFusion code: Query1.CurrentRow = #query1.CurrentRow# Using ColdFusion complex types in .NET input parameters When a .NET method returns an ArrayList, Hashtable, or DataTable, ColdFusion automatically converts it to a ColdFusion array, structure, or query, respectively. However ColdFusion does not automatically convert from ColdFusion data types to these .NET types. (ColdFusion does automatically convert ColdFusion arrays to .Net array types.) Therefore, you cannot use ColdFusion variables directly as input parameters to .NET object instance methods that require .NET System.Collection.ArrayList, System.Collection.Hashtable, or System.Data.DataTable types. Instead create instances of these .NET types and populate them with the required data before you pass them to the .NET method. For an example of creating and populating a System.Collection.Hashtable object, see the example at the end of the "Converting data to System.Object type" section. Last updated 1/20/2012