C# Tutorial - Print DataGridView with Header and Footer | FoxLearn

[@ga7853]

I am so addicted to you videos, never happened to me before, Thanks a million for all those wonderful tutorial you presented to us.

[@foxlearn]

Thank you so much !

[@insomanic778]

Man, you saved my job! This class is amazing! Thank you so much!

[@foxlearn]

You're welcome. thank you !

[@Unknown-bm5ui]

شكرا جزيلاً لك. مبارك من قبل الرب❤️🤲.

[@stephandre1094]

Thanks for this and then how use it in WPF application project ?

[@nicohadi5218]

@Fox Learn there's an issue when DataGridViewAutoSizeColumnsMode = Fill , the columns are separated in different pages, even I manually set it to None before passing it to PrintDataGrid, is there a workaround here? PS: When the DataGridViewAutoSizeColumnsMode = None on runtime , its working fine

[@foxlearn]

Thank you. Let me check again

[@kusumnet]

where is the class DGVPRINTER Can you please show what you wite in that?

[@in2raju498]

Thank you very much........................

[@miguelsaavedra6629]

Hola nos podría habilitar el DGVPrinter para poder descargarlo

[@cleyva]

Hello, could you please help me with the code to download the DGVPrinter?

[@maurodias2769]

thank you very much you help me a lot I love your channel

[@foxlearn]

You’re welcome. Thank you

[@sheebanismail7007]

Hey! How can I adjust number of columns in printview? It prints only 3 columns in one page and takes others to next page.

[@agbsoftware8018]

Thanks for share :) i have a question with your class how can write a text under datagridview, ? i need write the subtotal, and total

[@ekren20]

thank you for all...

[@mostafakhorami7789]

Hey can u give me permission to download from google drive th dgvprinter class? Tanx❤

[@hamzik2255]

this is amazing bro but why this doesnt work forme when i have more columns like 15 or more?

[@karalord5314]

Thanks ...Just perfect working..Excelente....

[@foxlearn]

Thank you !

[@jonathanvargas8371]

I congratulate you are very good your videos recently you are sealed but I like many your videos is more recommended to my friends to follow you

[@mindgamessoftwaredevelopme7726]

DGVPrinter error after using DGVPrinter please help !!!!

[@code4devsprogramming124]

Thanks bro..you give me an idea for my next project..😀

[@saifsameer1199]

Thank you, can you add the print code from right to left

[@Toturials]

thanks, How to print preview.

[@manly_garroway]

I'm creating the data in the datagridview virtually, but when I get the output, I encounter an empty table. What could be the reason?

[@syedhamza5341]

where to get dgvPrinter class?

[@govindsarda6919]

you are the BEST Bro...!!!!!!

[@foxlearn]

Thank you so much !

[@chipaxd438]

nice proyect, this helpme much, thanks.!!!!

[@foxlearn]

Thank you !

[@maymaracademy6998]

is it possible to add an image as header....? or any suggestions so i can modify your DGVPrinter Class to tweak.....

[@taltnamartkelaa]

thank you very much Do you have a VB.Net tutorial like this?

[@foxlearn]

At this time no, but i'll upload soon

[@gameplaymemoriesYT]

Great Work Fox Learn! btw how can I change the header font style? and also my datagridview have a color alternative, how can i print only some column and without the color in header and row?

[@abraofrancisco7198]

Hi Fox Learn! How can I set the page on horizontal ?

[@asvexx9525]

I was also looking for this funcuon. Thank you.

[@luun9549]

how do i print multiple datagriedview under each other ?

[@MrYemenBoy]

Nice videos and music

[@gameplay4u296]

its very helpful thanxxxx FOX LEARN..i have a little problem i want to get data specific according to query not all the table to print..what should i do plz help....

[@foxlearn]

Hi, You can use linq to query data For Example (var query = from o in db.Customers where o.City == "Your condition" select o).ToList() Thanks you

[@gameplay4u296]

Thank u soo much ..............

[@gameplay4u296]

i can use (and) with where clause?????????? how???????

[@foxlearn]

Hi, You can use where o.City == "Your condition" && o.PostalCode == "Your postal code". Thanks

[@gameplay4u296]

Thank uuuuuuuu soo much....my problem solved thax for your guide..

[@ishakmco3186]

Please link icant access to download class

[@bluevels]

Hi thanks very much for the video, helped me a lot. I want to know if you can add a normal text after the datatable.

[@garyvalverde9123]

Thank you very much, idols

[@foxlearn]

Thank you !

[@raffaele6577]

Hello, How Can I fit the columns of the DGV in one page? Now when I print the DGV I see more than 1 page because the DGV is too large..

[@lazerlight3385]

Hey I'm trying to figure out how to do this could you share, if you found a solution?

[@raffaele6577]

@@lazerlight3385 I used report RDLC and I put only the relevant columns

[@rong111y]

It works well for my form apps, thanks, can you also modify it in order to work for WPF?

[@foxlearn]

OK. Thank you for your suggestion. Let me try to research

[@mlambogavin6305]

nice video but its only display 3 columns instead of 5 column in my datagridview what ill be the problem

[@pXxDisasteRxXq]

ok, but how can I format the columns and rows dimensions and get sure that the datagridview will correctly put on a single page? cause if I have a "long" grid, with a lot of columns and long values in rows, I've seen that the procedure puts the grid on more sheets. how can I link the page dimensions with the datagridview rows and columns dimensions?

[@md.abdullahalmurad2312]

How can i print the values vertically in printed page?

[@alphatech7865]

Can you please solve this error in your given DGVPrinter file System.ComponentModel.Win32Exception: 'A StartDocPrinter call was not issued'

[@foxlearn]

OK. Thank you. I'll check again

[@coregamestudio]

Very nice, thank you for this explanation. I have a question. Q=When I print it I have 4 columns. It will print 2 columns on one page and 2 on another page. When I set Landscape it will print 3 columns on 1 page and 1 on the next. Is there a way to control column width. I saw DGVPrinter.ColumnWidthSetting but can not figure out how the column width is controlled. Any help appreciated pls.

[@coregamestudio]

Ok, hrm if you make the DGV smaller in the forms it prints on one page hehe. I would still like to figure out a command to change column width if anyone knows lol.

[@yusuftahakara6590]

@@coregamestudio did you solve this problem?

[@markroedroda]

@@coregamestudio did you solve the problem

[@katrykonig2466]

Is it possible to export it as pdf?

[@Coder_Satyabrata_S]

Very informative

[@mistersimple7303]

where to copy the dgvprint.cs, sir? Is it directly copy dgvprinter.cs to our projectfile? coz i dont see it when i try refreshing it inside visual studio interface

[@mistersimple7303]

well, i can make it manually from adding c# class. The thing is why can't I make model from database which already has table data? I mean it can be selected, but it wont appear in the model entities.

[@sergiogman]

thank you very much!! Recommended

[@UmarFarooq-jn7dt]

Thanks for the script. Means a lot.

[@sehhabadry4881]

how to print Landscape

[@RohitKumar-ys4ow]

can I use this in WPF aswell?

[@foxlearn]

I think no

[@hieplee5373]

Would you please show an example of how to print without prompting a print dialog? Thank you.

[@foxlearn]

bit.ly/2PXclHn . Thank you !

[@shubhamsahuSD]

can you video on creating a sql data structure for attendance in which employee or student names comes from another table. but i am bit confuse about attendance table dsign

[@foxlearn]

OK. Thank you for your suggestion

[@rangagurusinghe104]

Hi, my project language is VB , don't you have same solution in vb ?

[@foxlearn]

I'll upload version vb.net as soon as possible. Thank you

[@rangagurusinghe104]

thank you, I appreciate it. by the way I have another thing to know. If I hide a column in datagridview and then print , will it print the hided one as well or no ? Actually I want to print only visible columns and data in datagridview.

[@unpocodetodo-twitch7006]

in visual 2010 ?

[@alexeisafronov6627]

It's real is good content :) Very helpful class :)

[@foxlearn]

Thank you !

[@kashikhamani2500]

how can we increase grid header and rows column height and width on printing time thanks.

[@foxlearn]

You should use rdlc or crystal report, print datagridview too simple. Thank you !

[@knvnnnn]

how to adjust the paper size?

[@iandrilon8671]

I Have an error it showing The call Ambiguous between the following methods or properties how to solve this ?

[@ahmadarbilli4927]

pls how can i get DGVPrinter.dll file

[@masakrs]

Can you tell me is it possible to put landscape as default way of printing datagridview that im printing (idea is to rotate datagridview content before it hits the printer selection, so basically if I put landscape on printer it will print portrait), problem is that when I press "print" my printers are set to portrait by default, and I don't want change that coz ppl that r using my program usually print in portrait, so they will always have to change it just for this report

[@foxlearn]

Hi. You can view this video kzbin.info/www/bejne/Y4alZqB6hd10o9E to know how to do that. Thank you

[@makatinggolteb]

Hi, how do I write something on this report, for example I want to write something "Welcome" between the TItle and Subtitle? and also how can I input a logo in here? Thanks!

[@makatinggolteb]

nvm, I solved it by having printer.printDocument.PrintPage += PrintPage; and a PrintPage method, in this way you can modify the printing of document like adding images or your own texts with specified locations. PLEASE LIKE SO OTHERS CAN SEE THIS, IT WOULD HELP FOR SOMEONES. THANKS FOXLEARN!

[@foxlearn]

Hi, I think you should use Report Viewer instead print datagridview, see this video to solve kzbin.info/www/bejne/m5ycd3SOq7mkfdU , kzbin.info/www/bejne/gKDMfal3otCmmdE . Thank you

[@BigWaveyDavey]

Perhaps an easier way is to just insert a CR/NL after your title followed by welcome text: printer.Title = "First Line Title Here Welcome Message Here"

[@WaqasAli301]

Thanks for the great video.

[@foxlearn]

Thank you so much :)

[@jonathanvargas8371]

good evening! You could make the data of a datagrid be sent to another but of different form: Ejp: that the datagrid1 that you are in fom1 is sending data to the form2 of the datagrid2 and later and printing them

[@so2mali]

Thanks a lot.. It's very helpful..

[@foxlearn]

Thank you !

[@shubhamsahuSD]

can i change page resolution from a4 to a5 or a2

[@foxlearn]

I think you can. You can try var paperSize = printDoc.PrinterSettings.PaperSizes.Cast().FirstOrDefault(e => e.PaperName == "A5"); printDoc.PrinterSettings.DefaultPageSettings.PaperSize = paperSize;

[@shubhamsahuSD]

thanks, i were use it as printer.PageSettings.PaperSize.Height = Value of combobox ; and printer.PageSettings.PaperSize.Waidth = Value of combobox ; and value in combobox is predefined (e.g A4 = 210 × 297) now i will correct it

[@sheikhshuaib8451]

Hi ,great video but i have around 15 columns, so please show how to print the datagridview in landscape thanks

[@BigWaveyDavey]

printer.PageSettings.Landscape = true;

[@iostreamdoteych6013]

is this working on MySql Database?

[@muntaseradnan6964]

Works great Thanks :D

[@foxlearn]

Thank you :D

[@29miguel1996]

only work on visual basic 2015?

[@foxlearn]

Hi, You can work with C#, VB.NET on visual 2013/2015 . Thanks

[@makatinggolteb]

Hi, I have 9 Columns in my dgv, how do i make the printing to be landscape? TIA

[@foxlearn]

Hi, You can set PrintDocument pd = new PrintDocument(); pd.DefaultPageSettings.Landscape = true; Please try again. Thank you so much !

[@akhterhussain100]

how to print number of copies of one label ,i want input field for number of copies printing asp.net c#

[@foxlearn]

What do you mean? can you describe more details.

[@akhterhussain100]

@@foxlearn i want to print one page multiple time ,by input number of pages/copies to be print

[@jonasmwalula1760]

Hell there,thank you very much for this great tutorial, can you please tell me how to set the printing page orientation in Landscape?

[@foxlearn]

Ok. I'll research and update soon. thank you for your suggestion !

[@arek7893]

here you go printer.PageSettings.Landscape = true;

[@jhwils]

does this work in visual studio 2010

[@foxlearn]

Yes, It can work

[@jhwils]

Fox Learn thanks it work but who to change the row height

[@GEMLESTER]

you save me thanks a lot

[@foxlearn]

You're welcome :)

[@Luke-go1yb]

Hello, you really helped me with this one but i have one problem. I have 8 columns and want to print them on one page but the printer only puts 6 on one page and the other 2 on the next. Please help, thanks.

[@foxlearn]

I think you should use rdlc report or crystal report. thank you !

[@Blastpv]

found a solution to the issue?

[@yusuftahakara6590]

@@Blastpv did you find any solution?

[@Blastpv]

@@yusuftahakara6590 rdlc

[@yusuftahakara6590]

@@Blastpv thanks i will try. I put two datagridview and their one's visible is false other is true. They have same data. I resize datagridview which visible is false and its all columns seen in pdf.

[@siddalingeshapatil8973]

Hi.....My all code is correct but after printing i m getting each column in separate page only.....Please Any Answers ?????????????????????????????????????????????????????????

[@lisselcastelo9272]

Do you have VB.Net tutorial like this?

[@foxlearn]

At this time no, but i'll update vb.net soon for all tutorials

[@lisselcastelo9272]

+Fox Learn Thanks .. Godbless

[@aftabali9372]

why isn't savefiledialog opening when i click print please help me

[@marclouielopez7739]

What site i can download the DGV2Print ? Can you send me a link? Please because this is for my project mam / sir

[@foxlearn]

bit.ly/2PXclHn . Thank you !

[@marclouielopez7739]

i mean ma'am/sir the DLL or the extension you use the DGVPrinter.cs

[@marclouielopez7739]

please help me to solve this because this is my problem in my program

[@foxlearn]

Copy the class to your project, then rebuild the project. Remember change your namespace. thank you !

[@marclouielopez7739]

i try it .Thank you so much ! :)

[@waqarhussain5685]

please give me link to download DGVPrinter

[@bineyobengpeter8589]

Please give me the link to download DGVPrinter

[@luqmanehassane7609]

Hi everyone, someone can help me to get dgvprinter.dll?

[@SithuBoy]

Thank you..!

[@foxlearn]

You're welcome . Thank you !

[@joginderdumolia9045]

Hii i need mulitiple value insert in database in c# application

[@foxlearn]

Hi, You can use entity framework or dataset to save multiple value to your database. You can view this database kzbin.info/www/bejne/fJacmZmjo9OAoNE Thank you

[@joginderdumolia9045]

may you give me online class asp.net ,sir this is not multiple value i need one id and multiple row like genral store when we purchase more things ure name is only one but more item inserted in other row so tel me what wil do

[@joginderdumolia9045]

how to attac sql file with setup file of c# application plz make video

[@andrinovariswanto4653]

Oh hiii dude, im so surprise with your idea for create that class.. :D

[@foxlearn]

Thank you

[@darkblazer425]

Hi! How can i change the font style in title and subtitle thanks.!

[@foxlearn]

Print DataGridView too simple, you should use RDLC report, then you can change font size...etc

[@dhancomendoza1624]

is there any way to do this in vb.net

[@foxlearn]

OK. Thank you for your suggestion. I'll upload soon !

[@Gol_D_Roger_The_Pirate_King]

DGVprinter link is broken.

[@ishakmco3186]

❤❤❤❤

[@markfranklin2110]

I have a problem where I am printing from a datagridview but each column is printed in a new page, can you please advise? Thanks

[@foxlearn]

Hi, Make sure your code is correct. Please check again. Thank you

[@kashikhamani2500]

How do i increase Title fontsize

[@foxlearn]

Please try [your_grid].TitleFont = new Font("Times New Roman", 15.0f); . Thank you !

[@muhammadhassaan262]

Hi There.. I'm trying to print a data grid view but i'm getting 5 columns in one page and 4 columns on the other page.. Can you help me how to solve it??

[@muhammadhassaan262]

I've tried to change page preference to portrait to landscape. but tits not working..

[@foxlearn]

I think you should use rdlc or crystal report. print datagridview too simple

[@muhammadhassaan262]

@@foxlearn okay thanks..! :)

[@ajitnimbalkar2753]

Nice Tutorial. can u tell me how to show this two words like "Members" in left position and "Amount" in right position in footer.

[@foxlearn]

Hi, This .dll don't support. You can use Report Viewer. thanks

[@NicolePillmanVEVO]

hi, as active PrintPreviewDialog ? thx

[@foxlearn]

Thank you !

[@benjamarporns3319]

Copy DGVPrinter file to anywhere?

[@foxlearn]

Hi, You can download below this video. Thanks

[@WaqasAli301]

will u please tell me how can i Print to file instead of direct printing? i am stuck at this as i have to save document in pdf. reply please

[@foxlearn]

Hi, You need to install adobe pdf or pdf viewer. You can save the document to pdf file. thanks

[@charli384]

Excelente clase.. muchas gracias por compartir. Funciona de maravilla :). Excelent class, thx a lot for share. It works great :). Saludos de Perú

[@foxlearn]

Thank you so much :)

[@localistanpakistan35]

its really awesome

[@foxlearn]

Thank you !

[@anjeloxd7883]

can you use this in vb.net?

[@foxlearn]

Yes, You can do with VB.NET

[@mostafafatahalla9054]

wonderful

[@foxlearn]

Thank you

[@mahfuzurrahman2248]

It is very helpful .. Thanks to fox learn team.. I am having a problem in printing " When my DataGridVeiw contains more than 7 or 8 columns it prints rest columns in another page " So I need help how can i minimize the DataGridVeiw Size so that it can print more than 8 columns in one page Thanks in advance

[@foxlearn]

Hi, I think you should use Report Viewer or Crystal report: See kzbin.info/www/bejne/ZmicgH-DfNaNrck / kzbin.info/www/bejne/m5ycd3SOq7mkfdU . Thank you

[@sameerkhatri1918]

Hello Sir, If you have got the solution for this please let me know ASAP. Thanks. You can email me on [e-mail]

[@CH-qw6yy]

I loaded up the code and there are an abundance of errors. Not sure how everyone else got it working but as is I have a bunch of errors. So many its not worth trying to figure it out.