Category - Excel
Results 16 - 20 of 102
17 Oct 2018 17 Oct 2018 0 Comments  5173 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Crystal Report and download in Word, Excel, PDF and CSV file formats in ASP.Net MVC Razor.

Entity Framework will be used to populate Crystal Reports from SQL Server database in ASP.Net MVC 5 Razor.
16 Oct 2018 16 Oct 2018 0 Comments  7279 Views
Here Mudassar Ahmed Khan has explained with an example, how to display (embed) Excel Sheet on Web Page in ASP.Net using C# and VB.Net.

The Excel Sheet will be displayed (embedded) on Web Page with the help of IFRAME and Google Document Viewer in ASP.Net.
12 Oct 2018 12 Oct 2018 0 Comments  12366 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using WebGrid in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library into a DataSet and then the DataSet will be used to populate WebGrid in ASP.Net MVC Razor.
04 Oct 2018 04 Oct 2018 0 Comments  19164 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database using Stored Procedure in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a folder on Server. Then using Stored Procedure and OLEDB, the data from Excel file will be read and imported into SQL Server Database Table.
04 Oct 2018 04 Oct 2018 3 Comments  54405 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database in ASP.Net using C# and VB.Net.

The Excel Sheet data will be read into a DataTable and then then DataTable data will be imported into SQL Server Database using SqlBulkCopy in ASP.Net.
Results 16 - 20 of 102