How to Print Rows of SQL Database

[skylabnn]

Please how can I print the contents of SQL Database in VB6 Application?

I want to be able click a button in VB6 and it will print the rows of a SQL database. I want to print one row per page.

For e.g

Page 1
Name Surname Age



Page 2

Name Surname Age

[timon]

i think there must be option in file menu for printing other wise you can convert it to excel and go for print ...ActiveX Data Objects (ADO) provide access to any type of data source. It is a flat object model with few objects. check here for more How to import data from Microsoft SQL Server into Microsoft Excel

[pancham]

If you want to rewrite some modifications to an SQL table, first you need a select ZSQL method, and an Update SQL Tool Object. You need to use the fetchRow( ) and fetchInto( ) methods in your database and put data in numeric arrays. And in your program you need to use associative arrays or objects by passing an additional parameter to either method. For associative arrays, use DB_FETCHMODE_ASSOC:

create table utest
(id integer not null primary key,
name varchar(100) not null,
is_male smallint,
birth_date date,
birth_time time,
modified timestamp);

    while($row = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
        print $row['sign']."\n";
    }

    while($sth->fetchInto($row,DB_FETCHMODE_ASSOC)) {
        print $row['sign']."\n";
    }

For objects, use DB_FETCHMODE_OBJECT:

    while($row = $sth->fetchRow(DB_FETCHMODE_OBJECT)) {
        print $row->sign."\n";
    }

    while($sth->fetchInto($row,DB_FETCHMODE_OBJECT)) {
        print $row->sign."\n";
    }

[skylabnn]

Please can someone post a working example.

Preferably in a button click event.

I want to click a button in visual Basic an it will print SQL database contents to a selected printer.