exception

[NRHSR]

Object cannot be cast from DBNull to other types. code is flag = System.Convert.ToInt32(ord["flag"]); i have declared it as int and it can be null in table. can any body give solution for this..... quickly.......

[Abhishek Sur]

use int flag = (ord["flag"] == DBNull.Value ? default(int) : ord["flag"]); please replace the datatype of flag in default(int) to the data type of flag

Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions
Create .NET Templates

[NRHSR]

its not working

[Yusuf]

take Abhishek reply and apply casting.

Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

[Abhishek Sur]

yah.. need to cast means Convert.ToInt32(ord["flag"]) Now It will work.:rose:

Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions
Create .NET Templates

[keyur satyadev]

here you have declare the variable as nullable. int try it.