Column with Null value

[Mri1a]

hi!1 Actually i am a beginner with asp.net and databases . i want to know that how can i access values from a table where some column name has null value say parentId ..

Mrinal

[Mri1a]

what if one value is int type and the other is null type

Mrinal

[M LN Rao]

SqlDataReader r =//..some code.. int ParentId; //short form r.IsDBNull(r.GetOrdinal("ParentId"))?-1:Convert.ToInt32(r["ParentId"]); OR int ParentId = -1; if (!r.IsDbNull(r.GetOrdinal("ParentId"))) { ParentId = Convert.ToInt32(r["ParentId"]); }

Intelligence is measured by common sense not by how many scholarly books you read.

[Paddy Boyd]

SELECT AField FROM ATable WHERE parentId is null