ADO.NET中处理空置问题

判断数据库中的返回值是否为空:

MyWebDLL.DALStudents dalS = new MyWebDLL.DALStudents();
                int totalCount = 0;
                DataTable dt = dalS.GetStudentGetStudentInfoBySpecifiedPage(1, 3, out totalCount);
                //Console.Write(totalCount);

                if (dt.Columns.Count > 0)
                {
                    int recordCount = dt.Columns.Count;
                    for (int i = 0; i < recordCount; i++)
                    {
                        DataRow dr = dt.Rows[i];
                        int StudentId = (int)dr["StudentId"];
                        string StudentName = (string)dr["StudentName"];
                        int Age = (int)dr["Age"];
                        string Tel = (string)dr["Tel"];
                        string Address = (string)(dr["Address"] == DBNull.Value ? null : dr["Address"]);
                        Console.Write(StudentId + "\t");
                        Console.Write(StudentName + "\t");
                        Console.Write(Age + "\t");
                        Console.Write(Tel + "\t");
                        Console.Write(Address + "\r\n");
                    }
                }

其中,Address字段在数据库中是可空类型。则应用DBNull.Value来进行判断，若为空，则赋null

但是如果某字段为类似于int类型，不能直接赋值为空，则应该把该字段声明为可赋null值，如:

int? intCanBeNull = 0;
intCanBeNull = null;
if(intCanBeNull == null)
{
    //
}