How to check null values in dataset ?

Answers were Sorted based on User's Feedback



How to check null values in dataset ?..

Answer / jon

if(ds.Tables[0].Rows[0].IsNull(columnName)==true)
{
Response.write("Contains null value")
}

Is This Answer Correct ?    11 Yes 1 No

How to check null values in dataset ?..

Answer / divya

if (IsDBNull(ds.Tables(0).rows(0).Item("fldname")) then
Response.write("Contains null value")
end if

Is This Answer Correct ?    4 Yes 3 No

How to check null values in dataset ?..

Answer / sharad praskash singhania

If IsDBNull(ds) Then
Response.write("Null Value")
End If

Is This Answer Correct ?    1 Yes 1 No

How to check null values in dataset ?..

Answer / jha

if(dataSet.Tables[0].Rows[0].IsNull("ColumnName"))
{

<code>

}

Is This Answer Correct ?    0 Yes 0 No

How to check null values in dataset ?..

Answer / guest

Dataset.TableName[RowNumber].IsCOLUMNNAMENull

response.PayAnyonePaymentDetails[0].IsQueueNumberNull()

Is This Answer Correct ?    3 Yes 6 No

How to check null values in dataset ?..

Answer / fusion it

if dataset.tables(0).rows.count = 0

Is This Answer Correct ?    4 Yes 10 No

Post New Answer

More ASP.NET Interview Questions

Every Validation controls have same option ?

2 Answers   iGate,


Difference between .NET components and COM components?

2 Answers   Microsoft,


How can you apply a theme to your asp.net application?

0 Answers  


Usage of web.configuration ?

3 Answers   Microsoft,


Why the javascript validation not run on the asp.net button but run successfully on the html button?

0 Answers  


Explain the difference between overriding and overloading?

0 Answers  


Is object a value type or referenced type?

2 Answers  


To call a Web service SOAP which transport protocol you use?

3 Answers   Siebel,


What is viewstate parameter?

0 Answers  


What is gridview in asp.net?

0 Answers  


What is the server of asp.net?

0 Answers  


Should sn.exe be used before gacutil.exe ?

2 Answers   Accenture, BirlaSoft,


Categories