Category - SQL Server
Results 61 - 80 of 521
19 May 2021 19 May 2021 0 Comments  3359 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement HttpHandler (ASHX) in ASP.Net MVC Razor.

The HttpHandler (ASHX) will fetch data from SQL Server database using Entity Framework and return data in JSON format.

The HttpHandler (ASHX) will be called using a jQuery Client which will read the JSON values and populate it into an HTML Table in ASP.Net MVC Razor.
19 May 2021 19 May 2021 0 Comments  5782 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass parameters to the FromSql function of Entity Framework in ASP.Net Core.

The FromSql function of Entity Framework accepts the parameters as SqlParameter class objects.
19 May 2021 19 May 2021 0 Comments  7334 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the FromSql function of Entity Framework in ASP.Net Core.

The FromSql function is used to execute SQL Queries and Stored Procedures when using Entity Framework in .Net Core.
19 May 2021 19 May 2021 0 Comments  8206 Views
Here Mudassar Ahmed Khan has explained with an example, how to call Stored Procedure with parameters using Entity Framework in .Net Core 2.1.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework in .Net Core 2.1.
19 May 2021 19 May 2021 0 Comments  7772 Views
Here Mudassar Ahmed Khan has explained with an example, how to solve the error related to FromSql function of Entity Framework in .Net Core 2.1.

Error: DBSet<Entity> does not contain a definition for FromSql

The above error occurs because the namespace required to use the FromSql function has not been inherited.

The FromSql function belongs to the Microsoft.EntityFrameworkCore namespace.
18 May 2021 18 May 2021 0 Comments  11730 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net Core MVC.

The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net Core MVC.
30 Apr 2021 30 Apr 2021 0 Comments  9099 Views
Here Mudassar Ahmed Khan has explained with an example, how to delete data from Database using jQuery AJAX and Entity Framework in ASP.Net MVC Razor.

When the Delete Button is clicked, the DeleteCustomer Action method of the Controller is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, a Customer object is sent to the View which indicates that the record was successfully deleted or not.
29 Apr 2021 29 Apr 2021 0 Comments  10779 Views
Here Mudassar Ahmed Khan has explained with an example, how to update data into Database using jQuery AJAX and Entity Framework in ASP.Net MVC Razor.

When the Update Button is clicked, the UpdateCustomer Action method is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, a Boolean response is sent to the View which indicates that the record was successfully updated or not.
28 Apr 2021 28 Apr 2021 0 Comments  7612 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert data to Database using jQuery AJAX in ASP.Net MVC Razor.

The data will be inserted in SQL Server Database using Entity Framework in ASP.Net MVC Razor.

Finally, after insertion the ID of the inserted Customer record is returned back to the View in ASP.Net MVC Razor.
28 Apr 2021 28 Apr 2021 0 Comments  10149 Views
Here Mudassar Ahmed Khan has explained with an example, how to get data from Database using jQuery AJAX in ASP.Net MVC Razor.

This article will illustrate how to use jQuery AJAX function to get data from SQL Server database and then populate the data in an HTML Table using ASP.Net MVC Razor.
28 Apr 2021 28 Apr 2021 0 Comments  9426 Views
Here Mudassar Ahmed Khan has explained with an example, how to save Form data to Database using jQuery AJAX in ASP.Net MVC Razor.

When the Add Button is clicked, the InsertCustomer Action method is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, after insertion the ID of the inserted Customer record is returned back to the View in ASP.Net MVC Razor.
07 Apr 2021 07 Apr 2021 0 Comments  15358 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement CheckBoxes (CheckBoxList) in ASP.Net Core Razor Pages.

Group of multiple CheckBoxes (CheckBoxList) will be populated from SQL Server Database by looping through the Model.

The CheckBoxes are grouped by specifying common name for all CheckBoxes, this helps fetching their values as a collection in the Request header.
30 Mar 2021 30 Mar 2021 0 Comments  3075 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass (send) RadioButton value from View to Controller in ASP.Net Core MVC.

The RadioButtons will be populated from SQL Server database and when the Form is submitted, the value of the selected (checked) RadioButton will be sent to the Controller in ASP.Net Core MVC.
30 Mar 2021 30 Mar 2021 0 Comments  6369 Views
Here Mudassar Ahmed Khan has explained an example, how to display multiple CheckBoxes with Checked Unchecked values in ASP.Net MVC Razor.

The CheckBoxes along with their checked or unchecked (selected) values will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
14 Mar 2021 14 Mar 2021 0 Comments  14100 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind CheckBox (multiple CheckBoxes) using Model in ASP.Net Core MVC.

The generic list collection of Model class will be populated from Database inside Controller and then it will be used to populate the list of multiple CheckBoxes inside View in ASP.Net Core MVC.
14 Mar 2021 14 Mar 2021 0 Comments  8954 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind CheckBox (multiple CheckBoxes) using Model in ASP.Net MVC Razor.

The Database data will be populated in generic list collection of Model class and then the Model will be sent to the View where it will be bound to the CheckBox in ASP.Net MVC Razor.
09 Mar 2021 09 Mar 2021 0 Comments  24481 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement CheckBoxList (List of CheckBoxes) in ASP.Net Core MVC.

The records from the Database will be fetched from Database Table using ADO.Net into SelectListItem class as Model and a Custom CheckBoxList has been populated in ASP.Net Core MVC.
08 Mar 2021 31 Mar 2021 0 Comments  13566 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement RadioButtons (RadioButtonList) in ASP.Net Core MVC.

The records from the Database will be fetched from Database Table using ADO.Net into SelectListItem class as Model and a Custom RadioButtonList has been populated in ASP.Net Core MVC.

The RadioButtons are grouped by specifying common name for all RadioButtons in ASP.Net Core MVC.
05 Mar 2021 06 Apr 2021 0 Comments  10930 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement RadioButtons (RadioButtonList) in ASP.Net Core Razor Pages.

Group of multiple RadioButtons (RadioButtonList) will be populated from SQL Server Database by looping through the Model.

The RadioButtons are grouped by specifying common name for all RadioButtons in ASP.Net Core Razor Pages.
19 Feb 2021 19 Feb 2021 0 Comments  5281 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList using SelectListItem in ASP.Net MVC Razor.

The records from the database will be populated into a Generic List collection of SelectListItem class objects and then will be saved into a ViewBag object.

Inside the View, the ViewBag object will be passed to the Html.DropDownList Helper function for populating the DropDownList in ASP.Net MVC Razor.
Results 61 - 80 of 521