Is there a way you can generate all the data from a specific database table as a data sheet using a button click in C#? Is this possible using Visual Studio and SSMS? Thank you,
Asked
Active
Viewed 58 times
0
-
What's a "data sheet" in this context? – stuartd Apr 25 '17 at 11:26
-
What kind of datasheet! Post your expected output – Ali Rasheed Apr 25 '17 at 11:26
-
Like a table with the name of the columns and the data that a user can download locally not just show it like datagrids. Is this possible? – CodingLife Apr 25 '17 at 11:28
-
You basically want `.sql` of the database – Ali Rasheed Apr 25 '17 at 11:28
-
Do you want something like an excel spread sheet? – Dave Becker Apr 25 '17 at 11:29
-
Please can you explain and can you change that into a pdf file? Thank you for your feedback, – CodingLife Apr 25 '17 at 11:30
-
@DaveBecker yes like that. is it possible? – CodingLife Apr 25 '17 at 11:32
-
The easiest way would be to export the data to a `.csv` and import into excel. There are shed loads of posts on how to do this, this is just one: http://stackoverflow.com/questions/1963719/c-sharp-sqlserver-retrieving-results-and-place-in-a-csv-format – Dave Becker Apr 25 '17 at 11:40
-
If you want a datasheet you can generate a report in SQL Server which is a web applicaton. See : https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/reporting-services-report-server-sharepoint-mode – jdweng Apr 25 '17 at 12:28