How to print bill (invoice) from C#

Question

Hello, I need to print invoice (bill) and on the top of bill is some data (time, date, name bill number etc.) below is content of datagridview, and below is again some data. I don't know should I print this as CrystalReport  or as bitmap.

If I print as bitmap then I have problem because datagridview can have one row but sometimes can have more then one lines.

Any halp-suggestion how to print bill in C#.NET.

Thanks & Regards

Answer 1

this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter

sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;)

,but select statement is sytanx is some differ like this way

ample Select sql

sqlcommand cmd  = new sqlcommand("select * from [Sheet1$] where condition",con);

if it satisfies you accept this answer by clicking thumb up symbol

 

Answer 2

Hi chiranjeevi,

This is a simple application i did of your requirements.Run the attachments.


Thanks


If it helps you plz mark the answer as Accepted answer

Answer 3

Also look at the articles in this web site about Excel.