I am working on application in that fetching record from database.but when fetching char datatype of value is null then it shows error. here is my Code:
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lstServiceCall_Activity.Add(new OpportunityActivity()
{
Recontact = Convert.IsDBNull(reader["Recontact"]) ? (DateTime?)null : Convert.ToDateTime(reader["Recontact"]),
endDate = Convert.IsDBNull(reader["endDate"]) ? (DateTime?)null : Convert.ToDateTime(reader["endDate"]),
Details = (reader["Details"]) == DBNull.Value ? null : Convert.ToString(reader["Details"]),
Location = (reader["Location"]) == DBNull.Value ? 0 : Convert.ToInt32(reader["Location"]),
CardCode = (reader["CardCode"]) == DBNull.Value ? null : Convert.ToString(reader["CardCode"]),
Action = Convert.ToChar(reader["Action"]),
Priority = Convert.ToChar(reader["Priority"]),
CntctType = Convert.ToChar(reader["CntctType"]),
assignedTo = Convert.ToString(reader["AttendUser"])
}
);
}
for char how to set dbnull value. Please give some suggestion.