Tips Articles

Category - Tips

08 Nov 2021 Mudassar Khan 0 Comments 2469 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 6500 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 8314 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 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 Mudassar Khan 0 Comments 19373 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 45152 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 35837 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 25511 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 37539 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 17236 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 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 Mudassar Khan 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 Mudassar Khan 0 Comments 28284 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 72730 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 52359 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 73748 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 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 Mudassar Khan 0 Comments 78386 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 104404 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 62301 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.