How to print Contents of DataGrid ? 1

[charleslau2855]

hi everybody,

Who have the idea to Print Contents of DataGrid by using vb.net? look like print data in the document!



Regards,
charles

 

[PGoRule]

Check out the following link:
Example

Sharing the best from my side...

--Prashant--

 

[PGoRule]

You need to change some part of the code in above example as given in FAQ's at the bottom of the same page.


Sharing the best from my side...

--Prashant--

 

[charleslau2855]

hi pgorule,

Thank you reply to me! Actually i already have see this example:

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

but this example is just print some of the data in datagrid, which mean it can't to full print the contents of datagrid.

Any idea for this?

regards,
charles

 

[charleslau2855]

hi everyone,

For the above question which i already solved, but not really completed! because if the contents of datagrid is very large/ big which mean the value is very big then the output still can't to full print out, because of limitation page width size report !

So, i got following the idea but i don't know how to do it...
which i want to export this contents of datagrid to microsoft excel. so how can i do for this? any suggestion, please help!

Thanks a lot!

Regards,
charles

 

[PGoRule]

Yes...That example prints if the contents are less and fitting to your page width. If you do paging on the contents, then you can print that page.
Exporting to Excel format seems nice one, but if the contents are really large, then this will consume more time to export in Excel format and then print.

Sharing the best from my side...

--Prashant--

 

[charleslau2855]

Thank you reply, pgorule!

Yes... my contents are really large. So, do you have this idea for export contents of DataGrid to excel file with VB.NET ??

thanks for ur help!

Regards,
charles

 

[PGoRule]

I just finished some work for this...here is simple code:

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim excel As New Excel.Application()
        excel.Application.Workbooks.Add(True)
        Dim dt As New DataTable()
        dt = Me.NorthwindDataSet.Tables(0)
        Dim cInd As Integer = 0
        For Each dc As DataColumn In dt.Columns
            cInd = cInd + 1
            excel.Cells(1, cInd) = dc.ColumnName
        Next
        Dim rInd As Integer = 0
        For Each dr As DataRow In dt.Rows
            rInd = rInd + 1
            cInd = 0
            For Each dc As DataColumn In dt.Columns
                cInd = cInd + 1
                excel.Cells(rInd + 1, cInd) = dr(dc.ColumnName).ToString
            Next
        Next
    End Sub

here you need to add COM reference for Ms-Excel Object library. Here I'm using a Dataset (NorthwindDataSet) that filled the DataGrid. You can save this document if you want before exiting from Sub.
Hope you will find this code helpful.

Sharing the best from my side...

--Prashant--

 

[charleslau2855]

Thank you a lot!

I got the error which "Type 'Excel.Application" is not defined!!!

For the above that you mention about need to add COM reference for Ms-Excel Object library.
So, How to add this? Sorry, give you a lot of trouble!
Because i still very fresh to learn this vb.net!

Thank you!

Regards,
charles

 

[PGoRule]

In solution explorer:
Find References...if not there Click on 'Show all files' button present in solution explorer window.
Right click on references...and Add Reference
In the dialog select COM tag.
Scroll down to get Microsoft Excel xx.x Object library - xx.x being the version number.
Say 'OK' and enjoy the code...

Sharing the best from my side...

--Prashant--

 

[charleslau2855]

Thanks for you!!!

Regards,
charles