SQL Server Articles

Category - SQL Server

25 Nov 2022 Mudassar Khan 0 Comments 1384 Views

ASP.Net SQL Server Entity Framework CSV MVC

Here Mudassar Khan has explained with an example, how to export data from database to CSV file in ASP.Net MVC Razor.

The data from the database is fetched using Entity Framework and a Comma Separated (Delimited) string is generated using StringBuilder class.

Finally, the generated string will be exported to CSV file in ASP.Net MVC Razor.

22 Nov 2022 Mudassar Khan 0 Comments 958 Views

ASP.Net SQL Server Entity Framework HTML Word Core Razor Pages

Here Mudassar Khan has explained with an example, how to export data from database to Word document in ASP.Net Core Razor Pages.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to Word document in ASP.Net Core Razor Pages.

22 Nov 2022 Mudassar Khan 0 Comments 979 Views

ASP.Net SQL Server Entity Framework HTML MVC Word Core

Here Mudassar Khan has explained with an example, how to export data from database to Word document in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to Word document in ASP.Net Core MVC.

22 Nov 2022 Mudassar Khan 0 Comments 781 Views

ASP.Net SQL Server Entity Framework HTML MVC Word

Here Mudassar Khan has explained with an example, how to export data from database to Word document in ASP.Net MVC Razor.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to Word document in ASP.Net MVC Razor.

15 Nov 2022 Mudassar Khan 0 Comments 710 Views

ASP.Net SQL Server Entity Framework HTML Core Razor Pages

Here Mudassar Khan has explained with an example, how to export data from database to HTML file in ASP.Net Core Razor Pages.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to HTML (.htm) file in ASP.Net Core Razor Pages.

15 Nov 2022 Mudassar Khan 0 Comments 827 Views

ASP.Net SQL Server Entity Framework HTML MVC Core

Here Mudassar Khan has explained with an example, how to export data from database to HTML file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to HTML (.htm) file in ASP.Net Core MVC.

15 Nov 2022 Mudassar Khan 0 Comments 963 Views

ASP.Net SQL Server Entity Framework HTML MVC

Here Mudassar Khan has explained with an example, how to export data from database to HTML file in ASP.Net MVC.

The data from the database is fetched using Entity Framework and dynamic HTML string is generated using StringBuilder class.

Finally, the generated HTML string will be exported to HTML (.htm) file in ASP.Net MVC Razor.

14 Nov 2022 Mudassar Khan 0 Comments 833 Views

ASP.Net SQL Server Entity Framework HTML MVC WebGrid

Here Mudassar Khan has explained with an example, how to export WebGrid to HTML File (HTML String) in ASP.Net MVC Razor.

First, the WebGrid will be populated from database using Entity Framework and then the generated HTML Table of WebGrid will be sent as HTML string to the Controller which will be exported to HTML (.htm) file in ASP.Net MVC Razor.

12 Nov 2022 Mudassar Khan 0 Comments 1369 Views

ASP.Net SQL Server GridView Entity Framework HTML Table Grid Core Razor Pages

Here Mudassar Khan has explained with an example, how to export (Grid) GridView to HTML File (HTML String) in ASP.Net Core Razor Pages.

First, the Grid (GridView) will be populated from database using Entity Framework and then the generated HTML Table of Grid (GridView) will be sent as HTML string to the Razor PageModel which will be exported to HTML (.htm) file in ASP.Net Core Razor Pages.

12 Nov 2022 Mudassar Khan 0 Comments 983 Views

ASP.Net SQL Server GridView Entity Framework HTML Table MVC Grid Core

Here Mudassar Khan has explained with an example, how to export (Grid) GridView to HTML File (HTML String) in ASP.Net Core MVC.

First, the Grid (GridView) will be populated from database using Entity Framework and then the generated HTML Table of Grid (GridView) will be sent as HTML string to the Controller which will be exported to HTML (.htm) file in ASP.Net Core MVC.

12 Nov 2022 Mudassar Khan 0 Comments 972 Views

ASP.Net SQL Server GridView Entity Framework HTML Table MVC Grid

Here Mudassar Khan has explained with an example, how to export (Grid) GridView to HTML File (HTML String) in ASP.Net MVC Razor.

First, the Grid (GridView) will be populated from database using Entity Framework and then the generated HTML Table of Grid (GridView) will be sent as HTML string to the Controller which will be exported to HTML (.htm) file in ASP.Net MVC Razor.

25 Aug 2022 Mudassar Khan 0 Comments 3515 Views

ASP.Net SQL Server Entity Framework HTML CSV Table Core Razor Pages

Here Mudassar Khan has explained with an example, how to export Grid (Html Table) data from database to CSV (Text) file in ASP.Net Core Razor Pages.

The Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Microsoft CSV (Text) file in ASP.Net Core Razor Pages.

25 Aug 2022 Mudassar Khan 0 Comments 1716 Views

ASP.Net SQL Server Entity Framework HTML CSV Table MVC Core

Here Mudassar Khan has explained with an example, how to export Grid (Html Table) data from database to CSV (Text) file in ASP.Net Core MVC.

The Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Microsoft CSV (Text) file in ASP.Net Core MVC.

25 Aug 2022 Mudassar Khan 0 Comments 3465 Views

ASP.Net SQL Server Entity Framework HTML Table Word Core Razor Pages

Here Mudassar Khan has explained with an example, how to export Grid (Html Table) data from database to Word file in ASP.Net Core Razor Pages.

The Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Word file in ASP.Net Core Razor Pages.

24 Aug 2022 Mudassar Khan 0 Comments 2031 Views

ASP.Net SQL Server Entity Framework HTML Table MVC Word Core

Here Mudassar Khan has explained with an example, how to export Grid (Html Table) data from database to Word file in ASP.Net Core MVC.

The Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Word file in ASP.Net Core MVC.

21 Aug 2022 Mudassar Khan 0 Comments 2045 Views

ASP.Net SQL Server Entity Framework DropDownList Core Razor Pages

Here Mudassar Khan has explained with an example, how to populate (bind) DropDownList from database using Entity Framework in ASP.Net Core Razor Pages.

This article will also explain how to add Default Item (Blank Item) to DropDownList at First position when populating from database using Entity Framework in ASP.Net Core Razor Pages.

21 Aug 2022 Mudassar Khan 0 Comments 1758 Views

ASP.Net SQL Server Entity Framework DropDownList MVC Core

Here Mudassar Khan has explained with an example, how to populate (bind) DropDownList from database using Entity Framework in ASP.Net Core MVC.

This article will also explain how to add Default Item (Blank Item) to DropDownList at First position when populating from database using Entity Framework in ASP.Net Core MVC.

17 Aug 2022 Mudassar Khan 0 Comments 4399 Views

ASP.Net AJAX SQL Server jQuery Entity Framework DropDownList Core Razor Pages

Here Mudassar Khan has explained with an example, how to populate one DropDownList based on another DropDownList selected value using jQuery AJAX in ASP.Net Core Razor Pages.

This article will illustrate a dependent Country, State and City DropDownLists which will be populated from database by making use of Entity Framework in ASP.Net Core Razor Pages.

17 Aug 2022 Mudassar Khan 0 Comments 5163 Views

ASP.Net AJAX SQL Server jQuery Entity Framework DropDownList MVC Core

Here Mudassar Khan has explained with an example, how to populate one DropDownList based on another DropDownList selected value using jQuery AJAX in ASP.Net Core MVC.

This article will illustrate a dependent Country, State and City DropDownLists which will be populated from database by making use of Entity Framework in ASP.Net Core MVC.

16 Aug 2022 Mudassar Khan 0 Comments 2885 Views

ASP.Net SQL Server Cryptography Encryption Core Razor Pages

Here Mudassar Khan has explained with an example, how to encrypt and store Username or Password in SQL Server Database Table and then fetch, decrypt and display it in ASP.Net Core Razor Pages.

The Username or Password will be first encrypted using Symmetric (Same) key AES Algorithm and then will be stored in the database.

The Decryption will be done by fetching the encrypted Username or Password from Database and then decrypting it using the same key that was used for encryption.