Category - SQL Server
Results 81 - 100 of 570
29 Jul 2021 29 Jul 2021 0 Comments  15308 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload (insert) and download (retrieve) Files from Folder (Directory) and Path in Database using Web API in ASP.Net MVC Razor.

The Web API will insert the File information into SQL Server database using Entity Framework while the actual File will be saved in Folder (Directory) in ASP.Net MVC Razor.

The Web API will be called using jQuery AJAX and the file will be uploaded to Database using HTML5 Form Data and XmlHttpRequest (XHR).
29 Jul 2021 29 Jul 2021 0 Comments  3780 Views
Here Mudassar Ahmed Khan has explained with an example, how to use, implement and populate Charts from database using Google Charts API in ASP.Net Core MVC.

This article will illustrate how to populate Pie and Doughnut Charts from database using the Google Charts API in ASP.Net Core MVC.
17 Jul 2021 17 Jul 2021 0 Comments  2443 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the CancelSelectOnNullParameter property in ASP.Net SqlDataSource.

The CancelSelectOnNullParameter property is used to cancel the SELECT query i.e. return no result when a parameter is NULL.
17 Jul 2021 17 Jul 2021 0 Comments  7359 Views
Here Mudassar Ahmed Khan has explained with an example, how to use NULL Parameters with SqlDataSource and how to pass NULL parameters to StoredProcedure using SqlDataSource in ASP.Net.

In this article, a GridView will be populated and filtered using a StoredProcedure and SqlDataSource in ASP.Net.
29 Jun 2021 29 Jun 2021 0 Comments  16891 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and then the data is downloaded as Excel file using ClosedXML Excel library in ASP.Net Core MVC.
29 Jun 2021 29 Jun 2021 0 Comments  24666 Views
Here Mudassar Ahmed Khan has explained with an example, how to read (import) Excel file in ASP.Net Core MVC.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database using SqlBulkCopy class in ASP.Net Core MVC.
29 Jun 2021 29 Jun 2021 0 Comments  17388 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataSet or DataTable to Excel file in ASP.Net Core MVC.

The data from the database is fetched using ADO.Net into a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
28 Jun 2021 28 Jun 2021 0 Comments  13262 Views
Here Mudassar Ahmed Khan has explained with an example, how to use a DataSet or DataTable as Model in View in ASP.Net Core MVC.

Though it is not a good practice to use to use DataSet or DataTable as Model in View in MVC Core architecture, thus user’s please make a note that this is just an informative article and does not recommend to use DataSet or DataTable as Model in View in ASP.Net Core MVC.
24 Jun 2021 24 Jun 2021 0 Comments  9400 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement multiple Selection DropDownList using jQuery Select2 plugin in ASP.Net Core Razor Pages.

The multiple Selection DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net Core Razor Pages.
22 Jun 2021 22 Jun 2021 0 Comments  8414 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Searchable DropDownList using jQuery in ASP.Net Core Razor Pages.

The Searchable DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net Core Razor Pages.
22 Jun 2021 22 Jun 2021 0 Comments  10712 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList from database using Entity Framework in ASP.Net Core Razor Pages.
15 Jun 2021 15 Jun 2021 0 Comments  10200 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement multiple Selection DropDownList using jQuery Select2 plugin in ASP.Net Core MVC.

The multiple Selection DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net Core MVC.
15 Jun 2021 15 Jun 2021 0 Comments  14720 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Searchable DropDownList in ASP.Net Core MVC.

The Searchable DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net Core MVC.
15 Jun 2021 15 Jun 2021 0 Comments  10400 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement multiple Selection DropDownList using jQuery Select2 plugin in ASP.Net MVC Razor.

The multiple Selection DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
12 Jun 2021 12 Jun 2021 0 Comments  3706 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the jQuery Select2 plugin with Html.DropDownList HTML Helper function in ASP.Net MVC Razor.

The DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
12 Jun 2021 12 Jun 2021 0 Comments  13751 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the jQuery Select2 plugin for DropDownList in ASP.Net MVC Razor.

The DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
02 Jun 2021 30 Nov 2022 0 Comments  29754 Views
Here Mudassar Khan has explained with an example, how to use Stored Procedure with parameters with Entity Framework Core Database First Approach in ASP.Net Core MVC.

Database First Approach means first the Database is configured and then it is connected to Application using Entity Framework Core.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework Core Framework in ASP.Net Core MVC.
02 Jun 2021 02 Jun 2021 0 Comments  5098 Views
Here Mudassar Ahmed Khan has explained a simple tutorial with an example, how to use Entity Framework Core with Database First Approach in ASP.Net Core MVC.

Database First Approach means first the Database is configured and then it is connected to Application using Entity Framework Core.

This article will explain how to configure Entity Framework Core and connect to SQL Server database and finally the fetched data is displayed in ASP.Net Core MVC.
02 Jun 2021 02 Jun 2021 0 Comments  25566 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Searchable DropDownList in ASP.Net MVC Razor.

The Searchable DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
27 May 2021 27 May 2021 0 Comments  18688 Views
Here Mudassar Ahmed Khan has explained with an example, how to create DropDownList with TextBox that allows user to type in ASP.Net using C# and VB.Net.

This article will illustrate use of ASP.Net AJAX ComboBoxExtender populated from SQL Server Database in ASP.Net with C# and VB.Net.
Results 81 - 100 of 570