Category - SQL Server
Results 81 - 100 of 521
19 Feb 2021 19 Feb 2021 0 Comments  7767 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert DropDownList selected value in SQL Server Database in ASP.Net Core MVC.

The selected value of the DropDownList will be inserted into SQL Server Database using Entity Framework in ASP.Net Core MVC.
16 Feb 2021 16 Feb 2021 0 Comments  18540 Views
Here Mudassar Ahmed Khan has explained an example, how to use the Select List asp-items Tag Helper in ASP.Net Core Razor Pages.

The the Select List asp-items Tag Helper is used for populating DropDownList in ASP.Net Core Razor Pages.
16 Feb 2021 16 Feb 2021 0 Comments  11040 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate Select List from Database in ASP.Net Core Razor Pages.

The records from the Database will be populated into Model class objects and then the Model will be used to populate the DropDownList using the new ASP.Net Tag Helpers in ASP.Net Core Razor Pages.
15 Jan 2021 15 Jan 2021 0 Comments  7199 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Model data from Controller to View in ASP.Net Core MVC.

The data from the SQL Server Database will be fetched using Entity Framework and populated into Model which will be later sent to the View in ASP.Net Core MVC.
02 Jan 2021 02 Jan 2021 0 Comments  29974 Views
Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with Windows Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with Windows Authentication, the Integrated Security property is set to TRUE.
02 Jan 2021 02 Jan 2021 0 Comments  34854 Views
Here Mudassar Ahmed Khan has explained with an example, how to set SQL Server Connection String in AppSettings.json in .Net Core and ASP.Net Core MVC.

SQL Server Database has two types of Connection Strings i.e. Windows Authentication and SQL Server Authentication.
02 Jan 2021 02 Jan 2021 0 Comments  23579 Views
Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with SQL Server Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with SQL Server Authentication, the User Id and Password of the SQL Server Database is specified.
15 Dec 2020 15 Dec 2020 0 Comments  12451 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core Razor Pages.

The data from the database is fetched using Entity Framework and then the data is exported and downloaded as Microsoft Excel file using ClosedXML Excel library which is a wrapper for OpenXml Excel library.
12 Dec 2020 15 Dec 2020 0 Comments  21495 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and then the data is exported and downloaded as Microsoft Excel file using ClosedXML Excel library which is a wrapper for OpenXml Excel library.
09 Dec 2020 09 Dec 2020 0 Comments  17908 Views
Here Mudassar Ahmed Khan has explained with an example, how to return an Excel File from Controller in ASP.Net MVC Razor using C#.

The Excel File will be generated from database using Entity Framework and then it will be returned from Action method of Controller with FileResult return type in ASP.Net MVC Razor.
07 Dec 2020 07 Dec 2020 0 Comments  20528 Views
Here Mudassar Ahmed Khan has explained with an example, how to split a String into Rows in SQL Server.

This article will illustrate how to create a function that will split a string separated (delimited) by comma, space or some other special characters into Table Rows in SQL Server.
28 Nov 2020 28 Nov 2020 1 Comments  16383 Views
Here Mudassar Ahmed Khan has explained with an example, how to save (upload) Image files to Database using Web API in ASP.Net MVC Razor.

The Web API will insert and retrieve Image files from SQL Server database using Entity Framework in ASP.Net MVC Razor.
28 Nov 2020 28 Nov 2020 0 Comments  4771 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API that gets data from SQL Server Database in ASP.Net MVC Razor.

This article will illustrate how to connect a Web API to Database using Entity Framework in ASP.Net MVC Razor.
27 Nov 2020 27 Nov 2020 0 Comments  4975 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API DELETE Action method in ASP.Net MVC Razor.

This article will illustrate how to create a DELETE Action method in Web API and use it for deleting records in Database using Entity Framework in ASP.Net MVC Razor.
27 Nov 2020 27 Nov 2020 0 Comments  7286 Views
Here Mudassar Ahmed Khan has explained with an example, how to delete data from Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Delete Button is clicked, the DeleteCustomer Action method of the Web API 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.
24 Nov 2020 24 Nov 2020 0 Comments  4153 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API POST Action method in ASP.Net MVC Razor.

This article will illustrate how to create a POST Action method in Web API and use it for inserting records in Database using Entity Framework in ASP.Net MVC Razor.
24 Nov 2020 24 Nov 2020 0 Comments  8425 Views
Here Mudassar Ahmed Khan has explained with an example, how to update data into Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Update Button is clicked, the UpdateCustomer Action method of the Web API 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.
24 Nov 2020 24 Nov 2020 0 Comments  5837 Views
Here Mudassar Ahmed Khan has explained with an example, how call (consume) Web API GET method in ASP.Net MVC Razor.

The Web API Action method will be called inside the MVC Controller’s Action method using HttpClient class in ASP.Net MVC Razor.
24 Nov 2020 24 Nov 2020 0 Comments  11990 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert data into Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Add Button is clicked, the InsertCustomer Action method of the Web API 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.
23 Nov 2020 23 Nov 2020 0 Comments  10248 Views
Here Mudassar Ahmed Khan has explained with an example, how to create Connection String in C# and VB.Net.

This article will illustrate how to create connection string for Windows and SQL Server based authentication for Windows Forms and Console Applications in C# and VB.Net.
Results 81 - 100 of 521