vb.net printing w/o Crystal Reports

[steve-russell]

I have a simple database (one table) created with Access. I have a
simple query and report in Access and it works great. I have recreated
the program in Visual Studio (vb) but can not figure out how to print
the columns of info to a printer. In all of the posts I have read with
similar questions, everyone answers "why dont you use Crystal?" I dont
want to. I want to give my little program away and dont want to deal
with CR. Here is the basics, table with five columns
(fname,lname,email,state,region). Used at tradeshows to keep track of
booth visitors and at end of event, print list of people by state or
region and give to booth workers to email thank you notes. I know how
to query and fill datagrid by state or region. I just want to send info
to printer and hand out to booth workers. Someone please show me how to
print out 200+ people in my table. Seems simple but can not find any
info (ANYWHERE) on this. Every post talks about printdocument and .txt
file. This is a database not a .txt file. Someone has this simple
answer. (actually it is more than one table but want someone to give a
simple example and I can do the other stuff)

Steve
st***********@hotmail.com

[RobinS]

Can't you just create a report in Access, run it from VB
using automation, and display the report for
printing/printpreviewing?

Or read the data into a recordset and export it into a tab-delimited
file and open it and print it?

Robin S.

<st***********@hotmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>I have a simple database (one table) created with Access. I have a
simple query and report in Access and it works great. I have recreated
the program in Visual Studio (vb) but can not figure out how to print
the columns of info to a printer. In all of the posts I have read with
similar questions, everyone answers "why dont you use Crystal?" I dont
want to. I want to give my little program away and dont want to deal
with CR. Here is the basics, table with five columns
(fname,lname,email,state,region). Used at tradeshows to keep track of
booth visitors and at end of event, print list of people by state or
region and give to booth workers to email thank you notes. I know how
to query and fill datagrid by state or region. I just want to send info
to printer and hand out to booth workers. Someone please show me how to
print out 200+ people in my table. Seems simple but can not find any
info (ANYWHERE) on this. Every post talks about printdocument and .txt
file. This is a database not a .txt file. Someone has this simple
answer. (actually it is more than one table but want someone to give a
simple example and I can do the other stuff)

Steve
st***********@hotmail.com

[Martin Z]

Well, if you're good with HTML, you could dump the data into a web page
and send the page to the printer. Quick googling reveals a nice
codeproject doodad that will take an HTML file and send it to the
printer:

http://www.codeproject.com/csharp/printhml.asp

Alternately, you could poke around for opensource reporting packages.
I'm pretty sure there isn't any functional reporting systems built into
DotNet otherwise.

st***********@hotmail.com wrote:

I have a simple database (one table) created with Access. I have a
simple query and report in Access and it works great. I have recreated
the program in Visual Studio (vb) but can not figure out how to print
the columns of info to a printer. In all of the posts I have read with
similar questions, everyone answers "why dont you use Crystal?" I dont
want to. I want to give my little program away and dont want to deal
with CR. Here is the basics, table with five columns
(fname,lname,email,state,region). Used at tradeshows to keep track of
booth visitors and at end of event, print list of people by state or
region and give to booth workers to email thank you notes. I know how
to query and fill datagrid by state or region. I just want to send info
to printer and hand out to booth workers. Someone please show me how to
print out 200+ people in my table. Seems simple but can not find any
info (ANYWHERE) on this. Every post talks about printdocument and .txt
file. This is a database not a .txt file. Someone has this simple
answer. (actually it is more than one table but want someone to give a
simple example and I can do the other stuff)

Steve
st***********@hotmail.com