Avoid getting NULL value

if(!IsPostBack){

//code here

}

Related articles

• Piggy.Link Allows Websites To Charge For Content Quickly And Get Paid In Bitcoin
• Web Designers Utah Sites Say “No” to Money; Gives Website Design for Trade
• 40 Explosive Tactics to Increase Website Traffic – Infographic
• Website Design: Digital Surgeons White Paper on the Fundamentals of Good Design

Check if value from SqlDataReader is null

TextBox1.Text = reader.IsDBNull(1) == true ? “” : reader.GetDecimal(1).ToString();

Related articles

• (55% Discount coupon) SQL Password Recovery
• What is the SQL Server 2016 Query Data Store?
• First Public Preview Of SQL Server 2016 Now Available For Download
• Looping fetch_assoc()

SQL make null

NULLIF(‘expression1′,’expression2’)

*if expression1 = expression2 return null

Related articles

• Raspberry Pi Android App communication
• self study of database management system
• OpenStack Trove and DBaaS API By @Fred_Dalrymple | @CloudExpo [#Cloud]
• Database Developer

Check if a string is null or empty

string.IsNullOrEmpty(variable);

Related articles

• What would be a good programming language to learn if you’re a beginner to programming?
• What in the World Are Those QR Codes?
• What is an an assembler?
• The key to learning how to code

Clear GridView

GridView1.DataSource = null;

GridView1.DataBind();

Related articles

• Installing Skype for Business Server 2015 Standard Edition Front End on Windows Server 2012R2 Step by Step
• Using SignalR for communication between two app parts in SharePoint 2013
• Preventing SQLIA and OJVMWCU, a web service utility for Oracle RDBMS
• Installing SiteFinity with IIS 8, SQL Server 2012, and Windows Server 2012

Kill session

1. Session.Abandon();
2. Session.Remove(“YourItem”);
3. Session[“YourItem”] = null;
4. Session.Clear();

Related articles

• Websites and Apps Vulnerable to Low-Bandwidth, Bot-Free Takedown
• Microsoft confirms zero-day bug in IE6, IE7 and IE8
• Programming Windows Identity Foundation
• EF 5 Unable to verify the compatibility of the model

Replace null value from database

String variable = reader.IsDBNull(11) == true ? “” : reader.GetString(11);

Related articles

• Database Developer
• How to recover SQL server database from corrupt mdf file
• What you must know about Oracle Apps Dba Jobs
• Database Transfer Task fails in WebSphere Portal Server v8.5