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]

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

[@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

[@stephandre1094]

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

[@kusumnet]

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

[@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

[@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

[@cleyva]

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

[@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?

[@maurodias2769]

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

[@foxlearn]

You’re welcome. Thank you

[@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

[@hamzik2255]

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

[@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

[@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.

[@svedalawoodcrafts]

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.

[@svedalawoodcrafts]

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]

@@svedalawoodcrafts did you solve this problem?

[@markroedroda]

@@svedalawoodcrafts did you solve the problem

[@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

[@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..

[@saifsameer1199]

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

[@abraofrancisco7198]

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

[@asvexx9525]

I was also looking for this funcuon. Thank you.

[@karalord5314]

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

[@foxlearn]

Thank you !

[@mostafakhorami7789]

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

[@code4devsprogramming124]

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

[@taltnamartkelaa]

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

[@foxlearn]

At this time no, but i'll upload soon

[@syedhamza5341]

where to get dgvPrinter class?

[@hieplee5373]

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

[@foxlearn]

bit.ly/2PXclHn . Thank you !

[@govindsarda6919]

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

[@foxlearn]

Thank you so much !

[@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

[@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?

[@miguelsaavedra6629]

Hola nos podría habilitar el DGVPrinter para poder descargarlo

[@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?

[@mindgamessoftwaredevelopme7726]

DGVPrinter error after using DGVPrinter please help !!!!

[@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

[@chipaxd438]

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

[@foxlearn]

Thank you !

[@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

[@alexeisafronov6627]

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

[@foxlearn]

Thank you !

[@ishakmco3186]

Please link icant access to download class

[@Toturials]

thanks, How to print preview.

[@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"

[@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.

[@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.

[@in2raju498]

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

[@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;

[@luun9549]

how do i print multiple datagriedview under each other ?

[@maymaracademy6998]

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

[@RohitKumar-ys4ow]

can I use this in WPF aswell?

[@foxlearn]

I think no

[@garyvalverde9123]

Thank you very much, idols

[@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 !

[@md.abdullahalmurad2312]

How can i print the values vertically in printed page?

[@mlambogavin6305]

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

[@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;

[@katrykonig2466]

Is it possible to export it as pdf?

[@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

[@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 !

[@so2mali]

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

[@foxlearn]

Thank you !

[@waqarhussain5685]

please give me link to download DGVPrinter

[@bineyobengpeter8589]

Please give me the link to download DGVPrinter

[@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

[@iandrilon8671]

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

[@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]

[@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

[@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..! :)

[@ekren20]

thank you for all...

[@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

[@iostreamdoteych6013]

is this working on MySql Database?

[@29miguel1996]

only work on visual basic 2015?

[@foxlearn]

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

[@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 ! :)

[@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.

[@ahmadarbilli4927]

pls how can i get DGVPrinter.dll file

[@Coder_Satyabrata_S]

Very informative

[@muntaseradnan6964]

Works great Thanks :D

[@foxlearn]

Thank you :D

[@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

[@sehhabadry4881]

how to print Landscape

[@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

[@sergiogman]

thank you very much!! Recommended

[@UmarFarooq-jn7dt]

Thanks for the script. Means a lot.

[@MrYemenBoy]

Nice videos and music

[@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

[@knvnnnn]

how to adjust the paper size?

[@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

[@Gol_D_Roger_The_Pirate_King]

DGVprinter link is broken.

[@dhancomendoza1624]

is there any way to do this in vb.net

[@foxlearn]

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

[@aftabali9372]

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

[@benjamarporns3319]

Copy DGVPrinter file to anywhere?

[@foxlearn]

Hi, You can download below this video. Thanks

[@WaqasAli301]

Thanks for the great video.

[@foxlearn]

Thank you so much :)

[@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.

[@andrinovariswanto4653]

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

[@foxlearn]

Thank you

[@chesterdelsocorro6225]

i have a number in rowheader but when i print, the cell was empty. i used printer.PrintRowHeaders = true;

[@foxlearn]

What error are you getting?

[@chesterdelsocorro6225]

@@foxlearn it does'nt have an error but the rowheader are empty when i print it out. i want the row number to be included in printing but it turn out blank. the rowheader contains the row number.

[@foxlearn]

You should use Report, print datagridview too simple

[@David-uc9dc]

in my Datagridview I have 11 rows but when I print it only comes out 7, how can I solve it?

[@Blastpv]

found a solution to the issue?

[@bertugfahriozer4675]

you must add this code for LANDSPACE -> printer.PageSettings.Landscape = true;

[@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

[@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 :)

[@NicolePillmanVEVO]

hi, as active PrintPreviewDialog ? thx

[@foxlearn]

Thank you !

[@luqmanehassane7609]

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

[@unpocodetodo-twitch7006]

in visual 2010 ?

[@kirankumary.k4062]

DGVPrinter.cs its Library Files? or program fiel? can you help me... if it is library file means send link plz one more Northwind.bak file also library file? send me a link how to donload and import it waiting for ur reply Thank You

[@foxlearn]

Hi, DGBPrinter.cs is a class library, You can download Northwind database at northwinddatabase.codeplex.com/ .Thank you

[@kirankumary.k4062]

Thank You Can you send video link how to import northwind database to vb10

[@kirankumary.k4062]

can you plz send me the video how to import Northwind library to visual studio 10

[@anjeloxd7883]

can you use this in vb.net?

[@foxlearn]

Yes, You can do with VB.NET

[@kashikhamani2500]

How do i increase Title fontsize

[@foxlearn]

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

[@GEMLESTER]

you save me thanks a lot

[@foxlearn]

You're welcome :)

[@SithuBoy]

Thank you..!

[@foxlearn]

You're welcome . Thank you !