Is it possible to iterate through an SQL database using generic coding?

Question

0.00/5 (No votes)

See more:

To be honest not sure, what angle to attack from. generally speaking I'm asking for links/suggestions. I want to learn here, so any sort of help is great in my eyes.

What I have tried:

I have an sql query line to extract the data, then a line to define the length of each column and finally a line that reformats the data to present in a different form/table.
which looks like code below:

dd key="LineFormat" value="BG{DATE}{TOTALCOUNT}{TOTALAMOUNT}{CASHCOUNT}{CASHAMOUNT}"/>

Posted 4-Sep-18 22:03pm

Graeme Cooper

Updated 5-Sep-18 1:21am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2018-09-05T01:21:00

Although I cannot share the code, itself, I can give you some thoughts on how you do a generic SQL sequence.

The application which I have creates an input screen (HTML form) which passes parameter to the server which executes a SQL Stored Procedure which returns the table data which is formatted into a table with named column headers. A form is important in that the page content, given a name for a control, will pass it's value to the SQL engine. Any number of controls.

Here's what I can do to help: If you want a very generic I/O system then the rules, interestingly, have to be very strict. In the above, the format of the stored procedure is very strict. Our DBA has used this for roughly 700 reports, which also include insert/update/delete and user-friendly filters.

A nearly universal Form->query->table setup. A good many bells-and-whistles, such as direct dump to Excel sheet (as XML). So, per the underlined section above, abstract what you are doing: such as 'all fields are the same.'