DateTime.Now.Hour is Integer value, and it varies from 0 to 23... try the code below:
string session = "";
if (DateTime.Now.Hour >= 6 && DateTime.Now.Hour < 12)
{
session = "Morning";
}
else if (DateTime.Now.Hour >= 12 && DateTime.Now.Hour < 18)
{
session = "Afternoon";
}
else if (DateTime.Now.Hour >= 18 && DateTime.Now.Hour < 20)
{
session = "Evening";
}
else
{
session = "Night";
}
query = "UPDATE Registration_Master SET session= '" + session +"' WHERE regCode= '" + code + "'";
com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
com.ExecuteNonQuery();