DataTable中包含科学计数法的字段转换为一般显示的方法

public DataTable transtorm(DataTable dt)
        {
            foreach (DataRow dr in dt.Rows)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    if (dr[dc].ToString().Contains("E"))
                    {
                        try
                        {
                            double baseNum = float.Parse(dr[dc].ToString().Substring(0, dr[dc].ToString().IndexOf("E")));
                            double power = float.Parse(dr[dc].ToString().Substring(dr[dc].ToString().IndexOf("E") + 1));
                            double num = Math.Pow(10, power);
                            double recentNum = baseNum * num;
                            dr[dc] = Math.Round(recentNum, 2);
                        }
                        catch (Exception)
                        {
                            
                           // throw;  对于包含E的非科学计数字段
                        }
                    }
                }
            }
            return dt;
        }