Create & Print DataGrid View from onclick event?

Question

I want to link to SQL Server and populate a datagrid view (Preferably hidden as I do not want the view shown if possible) then print the results all from the onclick event of a button on my windows form.

I know how to link to sql server no trouble. But creating a hidden datagrid view, I would think there would be a visible.no property somewhere, but I haven't yet been able to find that.

Printing...it looks like it is possible, but I would have to have the onclick event launch a new winform with a print/printpreview enabled and launch the print from there.

Is this somewhat in the ballpark of setting it up correctly or does someone have a better idea?

richard smith · Answer

When I click print it just prints a blank page even though my datagrid has data?

Upamanyu Roy Choudhury · Answer

Hi Richard Making a gridview invisible wont be a problem as you can set the Visible property to false or can place it inside a container like a panel or so an make its visibilty true or false. However to export it to excel you can export the data to the format you want. You can print a griview data in the following way http://csharp.net-informations.com/datagridview/csharp-datagridview-printing.htm http://msdn.microsoft.com/en-us/library/aa287528(v=vs.71).aspx Try it in this way if you cannot then kep me postedI will guide you.