Tips Articles

Category - Tips

08 Nov 2021 Mudassar Khan 0 Comments 1257 Views

SQL Server Tips

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 Mudassar Khan 0 Comments 1946 Views

SQL Server Tips Stored Procedures

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 Mudassar Khan 0 Comments 1697 Views

SQL Server Tips Stored Procedures

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 Mudassar Khan 1 Comments 77953 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 Mudassar Khan 0 Comments 14098 Views

Charts Google Tips

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 Mudassar Khan 0 Comments 34146 Views

ASP.Net Tips DropDownList MVC TextBox

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 Mudassar Khan 0 Comments 24555 Views

ASP.Net Excel GridView Tips FileUpload OpenXml ClosedXml

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 Mudassar Khan 0 Comments 19031 Views

ASP.Net GridView Tips

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 Mudassar Khan 1 Comments 28838 Views

ASP.Net Crystal Reports Tips Windows Forms Visual Studio

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 Mudassar Khan 0 Comments 13376 Views

ASP.Net Crystal Reports Tips Windows Forms Visual Studio

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 Mudassar Khan 1 Comments 48619 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 Mudassar Khan 1 Comments 27444 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 Mudassar Khan 0 Comments 23887 Views

ASP.Net GridView Tips

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 Mudassar Khan 0 Comments 62033 Views

ASP.Net Tips DropDownList

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 Mudassar Khan 1 Comments 45174 Views

ASP.Net Tips DropDownList

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 Mudassar Khan 4 Comments 58290 Views

SQL Server Tips

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 Mudassar Khan 1 Comments 59284 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 Mudassar Khan 0 Comments 71654 Views

ASP.Net C#.Net VB.Net Tips

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 Mudassar Khan 2 Comments 92695 Views

ASP.Net Tips

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 Mudassar Khan 0 Comments 52470 Views

JavaScript jQuery Tips HTML5

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.