Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> Windows Forms >> Windows Forms General

Printing a database

I would like to print all the tables in my database in my program which holds the databases and works with them, Any suggestions?

Thanks

Anthony

[163 byte] By [AnthoDesigns] at [2007-12-24]

«« The issue of 'Zoom' of 'Page'
»» IE 7 Frameset Resize Bug

# 1

What kind of database do you have?

ReneeC at 2007-8-31 >

top of Msdn Tech,Windows Forms,Windows Forms General...

# 2

OOps, heh, yeah...good question, someone might need to know that before helping someone like me...heh...heh...anyway, its in access

AnthoDesigns at 2007-8-31 >

# 3

are you asking on how to print records from your VB.NET application, which have records showing from retrieving the values from an MS Access database?

ahmedilyas at 2007-8-31 >

# 4

Yes'm

AnthoDesigns at 2007-8-31 >

# 5

you can use the System.Drawing.Printing namespace/classes to print to printer:

http://msdn2.microsoft.com/en-us/library/5ekk3hse.aspx

http://msdn2.microsoft.com/en-us/library/system.drawing.printing.printdocument.aspx

ahmedilyas at 2007-8-31 >

# 6

I've looked at some sample code from microsoft in the msdn library, buut its for framework 1.1 and im using VS2005...not to mention they describe how to print from a stream, i dont want to open a file and print the file, i just want to print directly from my application. Liike, printing a listbox or a richtextbox for example...Although in this case it would be a DataGridView or something that is able to hold DB Information.

AnthoDesigns at 2007-8-31 >

# 7

Thanks for the link, unfortunately ive been there... I received this from a discussion on here...but it doesnt quite work...and another unfortunate fact is that im not a very skilled programmer. =( Im learning though. =)

' Dim line As String

' For Each row As DataGridViewRow In CustomersDataGridView.Rows

'line = String.Empty

'For Each cell As DataGridViewCell In row.Cells

' line += cell.Value.ToString() & vbNewLine

' Next

' Dim font As New Font("Times New Roman", 12)

' Dim brush As Brush = Brushes.Black

' Dim x As Single = 20

' Dim x2 As Single = 100

' Dim y2 As Single = 100

' Dim y As Single = 20

' e.Graphics.DrawString(line, font, brush, x2, y2)

' Next

AnthoDesigns at 2007-8-31 >

# 8

Ill settle with anything really...maybe a way to generate a text file from the database, then print the text file...

Or perhaps, put all of the information into a rich text box, or some other type of object...I would just really like to be able to print...

thanks in advance

AnthoDesigns at 2007-8-31 >

# 9

VS2005 is .NET 2.0, not 1.1. Anything in 1.1 code can usually be done in .NET 2.0 unless otherwise stated in the articles/documentation

take a look at this:

http://www.codeproject.com/vb/net/datagridex.asp

its .NET 1.1 but should be the same for .NET 2.0, just changing the name of the components and its properties.

ahmedilyas at 2007-8-31 >

Windows Forms

Windows Forms General

Windows Forms Hot Topic

Windows Forms New Topic

Windows Forms

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech