New Additions
15 Oct 2020 15 Oct 2020 0 Comments  289 Views
Here Mudassar Ahmed Khan has explained with an example, how to execute Stored Procedure with Table Valued Parameters in SQL Server.

First a Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter.

Then it is passed as Parameter to the Stored Procedure and the Stored Procedure is executed using the EXEC command in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  249 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 1 Comments  199 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  186 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass TEMP Table as Parameter to Stored Procedure in SQL Server.

A TEMP Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  256 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Bootstrap DatePicker (Calendar) in ASP.Net Core Razor Pages.

This article will also illustrate how to get the selected Date of the Bootstrap DatePicker (Calendar) inside Controller on Button click in ASP.Net Core Razor Pages.

The Date format for the selected Date will be set to dd/MM/yyyy format.
17 Aug 2015 15 Oct 2020 0 Comments  9902 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table name as Parameter (Variable) to sp_executesql command in SQL Server.

The sp_executesql command supports accepting Table name as Parameter (Variable) in the following SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014, 2017, 2019 and higher.
13 May 2009 15 Oct 2020 2 Comments  77698 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table name dynamically to a query or stored procedure in SQL Server.

The sp_executesql command supports accepting Table name as Parameter (Variable) in the following SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014, 2017, 2019 and higher.
12 Jun 2015 15 Oct 2020 0 Comments  7003 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table as parameter i.e. Table Valued Parameters to Stored Procedure in SQL Server.

The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the Table Valued parameter that we need to pass to the Stored Procedure.
12 Jun 2014 15 Oct 2020 12 Comments  104386 Views
Here Mudassar Ahmed Khan has explained with an example, how to send (pass) DataTable as parameter to Stored Procedure using the SQL Server User Defined Table Type in ASP.Net with C# and VB.Net.

The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the DataTable that we need to pass to the Stored Procedure as parameter in ASP.Net with C# and VB.Net.
13 Oct 2020 13 Oct 2020 0 Comments  300 Views
ASP.Net  MVC  Email  Gmail  Core  .Net
Here Mudassar Ahmed Khan has explained with an example, how to send emails using GMAIL in ASP.Net Core.

This article will illustrate how to send emails with attachment using GMAIL SMTP Mail Server in ASP.Net Core.
13 Oct 2020 13 Oct 2020 0 Comments  246 Views
ASP.Net  MVC  Email  Gmail  Core  .Net
Here Mudassar Ahmed Khan has explained with an example, how to send emails in .Net Core.

This article will illustrate how to send emails with attachment using SMTP Mail Server in .Net Core.

This article will make use of GMAIL SMTP Server and SMTP Client class for sending emails in .Net Core.
09 Oct 2020 09 Oct 2020 0 Comments  325 Views
ASP.Net  AJAX  jQuery  MVC  Core
Here Mudassar Ahmed Khan has explained with an example, how to get Current Date and Time from Controller using jQuery AJAX in ASP.Net Core MVC.

The Current Date and Time will be determined inside the Controller’s Action method which will be later sent to the View for display using jQuery AJAX in ASP.Net Core MVC.
09 Oct 2020 09 Oct 2020 0 Comments  292 Views
Here Mudassar Ahmed Khan has explained with an example, how to set MaxRequestLength in ASP.Net Core.

The MaxRequestLength property is used to set the maximum upload File Size Limit in older ASP.Net versions.

But in ASP.Net Core, a new property, maxAllowedContentLength is used to increase the maximum upload File Size Limit.
09 Oct 2020 09 Oct 2020 0 Comments  255 Views
Here Mudassar Ahmed Khan has explained how to solve the following error in ASP.Net Core.

HTTP Error 404.13 - Not Found The request filtering module is configured to deny a request that exceeds the request content length.
08 Oct 2020 08 Oct 2020 0 Comments  385 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload multiple files with Drag and Drop in HTML5 supported browsers using jQuery and AJAX in ASP.Net Core MVC.

Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using the jQuery FileDrop plugin in ASP.Net Core MVC.
03 Oct 2020 03 Oct 2020 0 Comments  478 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload Large Files in ASP.Net Core.

The maximum upload File Size Limit in ASP.Net Core is 28 MB, which means user will not be allowed to upload Files of size greater than 28 MB.

Thus this article will provide details about how you can increase the limit and upload files greater than 28 MB in ASP.Net Core.
13 Jul 2015 29 Sep 2020 1 Comments  34831 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass multiple Eval (DataBinder.Eval) values as parameter to JavaScript function in ASP.Net using C# and VB.Net.

The multiple Eval (DataBinder.Eval) values from database are passed to a JavaScript function as parameters when Button is clicked inside GridView control.
26 Aug 2016 29 Sep 2020 9 Comments  323492 Views
Here Mudassar Ahmed Khan has explained with an example, how to submit (post) a Form and send data from View to Controller in ASP.Net MVC 5.

This article will explain how to create Form Fields using Model class and then send data from View to Controller using Model class object in ASP.Net MVC 5.
08 Mar 2017 29 Sep 2020 0 Comments  208472 Views
Here Mudassar Ahmed Khan has explained a simple tutorial with example on how to use Html.BeginForm extension method in ASP.Net MVC Razor.

The Html.BeginForm extension method is used to generate an HTML Form Tag in ASP.Net MVC Razor.
19 Aug 2016 29 Sep 2020 2 Comments  45200 Views
Here Mudassar Ahmed Khan has explained a simple tutorial with an example, how to use Simple Entity Framework in ASP.Net MVC 5.

This article will explain how to configure Entity Framework and connect to SQL Server database and finally the fetched data is displayed in View.
21 Jun 2019 29 Sep 2020 0 Comments  7664 Views
Here Mudassar Ahmed Khan has explained with an example, how to use Repeater control functionality in ASP.Net MVC Razor.

In ASP.Net MVC, there is no provision of using Web Forms controls such as Repeater control, but the same functionality can be easily achieved with the use of Model collection and FOR loop.
19 Aug 2016 29 Sep 2020 0 Comments  30980 Views
Here Mudassar Ahmed Khan has explained a simple tutorial with an example, how to use Entity Framework with Database First Approach in ASP.Net MVC 5.

This article will explain how to configure Entity Framework and connect to SQL Server database and finally the fetched data is displayed in View.
15 Nov 2018 29 Sep 2020 0 Comments  2939 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass (send) List Collection from Controller to View in ASP.Net MVC Razor.

This article will illustrate how to fetch data from Database using Entity Framework and then send the Data from Controller to View in a Generic List Collection format in ASP.Net MVC Razor.
26 Sep 2016 29 Sep 2020 0 Comments  29431 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform Client Side validations using Data Annotation attribute and jQuery in ASP.Net MVC Razor.

The Client Side validations will be performed using Model class and Data Annotation attributes.
02 Dec 2013 29 Sep 2020 11 Comments  193401 Views
Here Mudassar Ahmed Khan has explained how to pass value from child popup window to parent page window using JavaScript.

The child popup window must be opened using JavaScript window.open function. And in such case we can access the parent page controls using JavaScript window.opener instance.