devxlogo

A Better Way to Retrieve Row and Column Data

Why Trust Us

Instead of creating a GridControl to retrieve row and column data from a table into a hash table, use a variant, as shown:

 variant = new Variant();for (row2get=0;     row2get < queryDataSet1.getColumnCount();     row2get++) {  for (column2get=0;       column2get < queryDataSet1.getColumnCount();       column2get++) {         queryDataSet1.getVariant(int row2get,            int column2get,variant);         String bean = (String)variant;         HashTable.put("columnName",            new String(bean));    }}

You can now cast the data from the variant object to the appropriate type to retrieve the information. This is particularly handy when serializing an object created from a database, since you can ask for the data by column name. You can also use "tiered hash tables" to capture master-detail relationships.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  How Seasoned Architects Evaluate New Tech
Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More