Category - Tips
Results 1 - 20 of 51
08 Nov 2021 08 Nov 2021 0 Comments  2469 Views
Here Mudassar Ahmed Khan has explained with an example, how to use WHILE LOOP in SQL Server (Transact-SQL).

The WHILE statement as used in various programming languages works in similar way in SQL Server. It is a control flow statement and it is used to perform iterations until the condition holds TRUE.
14 Sep 2021 14 Sep 2021 0 Comments  6500 Views
Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging using Common Table Expression (CTE) in SQL Server.
04 Sep 2021 04 Sep 2021 0 Comments  8314 Views
Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging along with Total Row Count in SQL Server.

This article will illustrate how to implement Paging in Stored Procedure using TEMP Tables in SQL Server.
17 Jun 2020 17 Jun 2020 2 Comments  173320 Views
ASP.Net  Excel  Tips  OLEDB
Here Mudassar Ahmed Khan has explained how to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit.

In order to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit, you will need to download the Microsoft Access Database Engine 2010 Redistributable file.
04 Jun 2019 04 Jun 2019 0 Comments  19373 Views
Here Mudassar Ahmed Khan has explained with an example, how to hide Legend in Google Charts.

By default, legend is always shown in Google Chart and in order to hide legend, it needs to be disabled using Google Chart Options.
18 Jun 2018 18 Jun 2018 0 Comments  45152 Views
Here Mudassar Ahmed Khan has explained with an example, how to clear Model Fields such as TextBox, DropDownList, RadioButtons, CheckBoxes, ListBox etc. after Form Submit in ASP.Net MVC Razor.

The Form Fields which are created using Model class retain the values even after Form submission and hence to clear such Form Fields, Model state needs to be cleared.
01 Jun 2018 01 Jun 2018 0 Comments  35837 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file directly from Stream without saving in Folder (Directory) on Server’s Disk in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml, the Excel file data can be easily read from the InputStream property.
22 May 2018 22 May 2018 0 Comments  25511 Views
Here Mudassar Ahmed Khan has explained with an example, how to render GridView with THead, TBody and TFoot tags in ASP.Net using C# and VB.Net.

By default, GridView renders as HTML Table without the THead, TBody and TFoot tags.
29 May 2017 29 May 2017 1 Comments  37539 Views
Here Mudassar Ahmed Khan has explained with an example, how to change and set Height and Width of Crystal Reports in Visual Studio.
29 May 2017 29 May 2017 0 Comments  17236 Views
Here Mudassar Ahmed Khan has explained with an example, how to hide Group Tree Panel in Crystal Reports. The Group Tree Panel can be hidden using a property of the Crystal Report Viewer control in Visual Studio.
21 Nov 2016 21 Nov 2016 1 Comments  56007 Views
ASP.Net  Tips  MVC
Here Mudassar Ahmed Khan has explained with an example, how to display data in Single View from Multiple Tables in ASP.Net MVC Razor.
By default, a View can be associated with only one Model and hence this article will explain how to display data in Single View from Multiple Tables using Multiple Models in ASP.Net MVC Razor.
18 Nov 2016 18 Nov 2016 1 Comments  33180 Views
ASP.Net  Tips  MVC
Here Mudassar Ahmed Khan has explained with an example, how to pass (send) Multiple Models to one View in ASP.Net MVC Razor.
By default, a View can be associated with only one Model and hence this article will explain how to pass (send) Multiple Models to one View in ASP.Net MVC Razor.
15 Jan 2016 15 Jan 2016 0 Comments  28284 Views
Here Mudassar Ahmed Khan has explained with an example, how to display multiple data Fields (Columns) in GridView BoundField in ASP.Net.
By default, the BoundField column of GridView does not allow to show multiple data Fields (Columns), thus the solution is to use TemplateField or using the RowDataBound event, multiple data Fields (Columns) can be displayed in BoundField column of GridView.
29 Dec 2015 29 Dec 2015 0 Comments  72730 Views
Here Mudassar Ahmed Khan has explained with an example, how to add item at Index 0 (First position) in ASP.Net DropDownList that already contains items (data) using C# and VB.Net.
29 Dec 2015 29 Dec 2015 1 Comments  52359 Views
Here Mudassar Ahmed Khan has explained with an example, how to add default (insert) Blank (Empty) item to DataBound DropDownList populated from Database in ASP.Net Code Behind using C# and VB.Net.
Generally we want to have a default selected item such as Please Select with Blank (Empty) value. This article will explain how to add such Blank (Empty) item in Code Behind when DropDownList is populated from database.
23 Nov 2015 23 Nov 2015 4 Comments  73748 Views
Here Mudassar Ahmed Khan explained with an example, how to use Comma Separated (Delimited) string values with IN and WHERE clause in SQL Server.
This article is applicable to all SQL Server versions i.e. 2005, 2008, 2012 and 2014.
25 Oct 2015 25 Oct 2015 1 Comments  77252 Views
Tips  IIS
Here Mudassar Ahmed Khan has explained with an example, how to enable 32 bit Applications in Application Pool of IIS Server versions IIS 7 and IIS 8.
In 64 Bit windows server operating systems, by default 64 Bit .Net Framework installed and hence when you try to deploy a 32 Bit application (website) on IIS Server it results in an error.
01 Sep 2015 01 Sep 2015 0 Comments  78386 Views
Here Mudassar Ahmed Khan has explained with an example, how to generate unique Random Strings containing Letters and Numbers (AlphaNumeric) and Numbers (Numeric) in ASP.Net using C# and VB.Net.
The unique Random Strings containing Letters and Numbers (AlphaNumeric) and Numbers (Numeric) will be generated in variable lengths such as 5, 8 and 10 characters in ASP.Net using C# and VB.Net.
31 Aug 2015 31 Aug 2015 2 Comments  104404 Views
Here Mudassar Ahmed Khan has explained with an example, how to generate Unique Random OTP i.e. One Time Password in ASP.Net using C# and VB.Net.
OTPs or One Time Passwords are widely used by banks and other firms to validate the Mobile Numbers of their users. OTPs can be Alphanumeric as well as Numeric and generally have length between 5-10 characters.
20 Aug 2015 20 Aug 2015 0 Comments  62301 Views
Here Mudassar Ahmed Khan has explained with an example, how to change the URL in browser address bar without reloading or refreshing the page using HTML5 History API in JavaScript and jQuery.
HTML5 History API allows browsers to change the URL in browser address bar without reloading or refreshing the page using pushState function.
Results 1 - 20 of 51