SQL Server Articles

Category - SQL Server

21 Nov 2020 Mudassar Khan 0 Comments 104 Views

ASP.Net ADO.Net SQL Server Entity Framework Core Razor Pages

Here Mudassar Ahmed Khan has explained with an example, how to do a Database Connection without using Entity Framework in ASP.Net Core Razor Pages.

This article will illustrate how to connect to Database using ADO.Net and fetch data from Database using SqlDataReader in ASP.Net Core Razor Pages.

21 Nov 2020 Mudassar Khan 0 Comments 83 Views

ASP.Net ADO.Net SQL Server Core Razor Pages

Here Mudassar Ahmed Khan has explained with an example, how to use ADO.Net Database Connection in ASP.Net Core Razor Pages.

This article will illustrate how to connect to Database using ADO.Net and fetch data from Database using SqlDataReader in ASP.Net Core Razor Pages.

21 Nov 2020 Mudassar Khan 0 Comments 98 Views

ASP.Net ADO.Net SQL Server DropDownList Core Razor Pages

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

The records from the Database will be fetched from Database Table using ADO.Net into Model class object and then the Model is used to populate the DropDownList using the new ASP.Net Tag Helpers in ASP.Net Core Razor Pages.

21 Nov 2020 Mudassar Khan 0 Comments 109 Views

ASP.Net ADO.Net SQL Server DropDownList MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to retrieve data from Database and displaying in DropDownList in ASP.Net MVC Core.

The records from the SQL Server Database will be retrieved from Table using ADO.Net into Model class object and then the Model is used to display the data in the DropDownList in ASP.Net Core MVC.

21 Nov 2020 Mudassar Khan 0 Comments 90 Views

ASP.Net SQL Server Entity Framework MVC

Here Mudassar Ahmed Khan has explained with an example, how to get Auto Increment Primary Key with Entity Framework Database First using C# in ASP.Net MVC Razor.

When the Form is submitted, the value of the submitted Form fields will be fetched using Entity Framework Model class object and will be inserted into database using Entity Framework. After successful insert, the ID of the last inserted record fetched using SCOPE_IDENTITY will be displayed using JavaScript Alert Message Box.