Find Min/Max Value FROM datatable

private void populateMaxOrMinValue(DataTable dtRef)
{
 if (dtRef.Rows.Count > 0)
        {
        //////////PICK THE MAX VALUE FROM DATATABLE USING ENUMERABLE
         maxValue = dtRef.AsEnumerable()
               .Where(ss => double.TryParse(ss["value"].ToString(), out val))
               .Select(ss => Convert.ToDouble(ss["value"])).Max();
         //////////PICK THE MIN VALUE FROM DATATABLE USING ENUMERABLE
         minValue = dtRef.AsEnumerable()
                .Where(ss => double.TryParse(ss["value"].ToString(), out val))
                .Select(ss => Convert.ToDouble(ss["value"])).Min();
         //////////////////////////////////////////////
 }
}

Update Table by Joining In sqlserver

UPDATE X SET X.cloumnNanme = s.columnName ,X.cloumnNanme = s.cloumnNanme
FROM UpdatedTableName X INNER JOIN
ValueTableName s
ON(s.cloumnNanme = X.cloumnNanme)